庫存扣除需求 有先後 (12155)

(先)H8=MAX(VLOOKUP(F8,F$3:I$4,3,)-SUMIF(B:B,F8,C:C),)

(次)G8=SUMPRODUCT(VLOOKUP(F8,F$3:I$4,{2,3},))-SUMIF(B:B,F8,C:C)-H8

(後)I8=G8+H8