進銷貨統計 指定日期空白表全部 (13399)

E2=IF(A2="","",SUM(SUMIFS(D$2:D2,B$2:B2,B2,C$2:C2,{"進貨","銷貨"})*{1,-1}))

J2:KK4=SUMPRODUCT($D$2:$D$999*($A$2:$A$999=IF($G$2="",$A$2:$A$999,$G$2))*($B$2:$B$999=$I2)*($C$2:$C$999=LEFT(J$1,2)))