進銷貨統計 (13398)

G3G19=SUMIF(E$3:E3,"進貨",F$3:F3)-SUMIF(E$3:E3,"銷貨",F$3:F3)

G3G19另解=SUM(SUMIF(E$3:E3,{"進貨","銷貨"},F$3:F3)*{1,-1})

I3:J3=SUMIF($E:$E,LEFT(I2,2),$F:$F)

K3=I3-J3