先进先出 計成本總价 (10099)

D11=SUMPRODUCT(FREQUENCY(ROW(INDIRECT(SUM(C$10:C10)+1&":"&SUM(C$11:C11))),SUMIF(OFFSET(B$3,,,ROW($1:$5)),B11,D$3:D$7))*E$3:E$8)