计算库存 (10868)

F2=SUMIFS(D$2:D2,B$2:B2,B2,C$2:C2,"入库")-SUMIFS(D$2:D2,B$2:B2,B2,C$2:C2,"出库")

另解=SUM(SUMIFS(D$2:D2,B$2:B2,B2,C$2:C2,{"入库","出库"})*{1,-1})

另解=SUMPRODUCT((B$2:B2&C$2:C2=B2&"入库")*D$2:D2-(B$2:B2&C$2:C2=B2&"出库")*D$2:D2)