買賣多維合計 (11670)

J2:N5=SUMIFS($C:$C,$E:$E,$H2,$B:$B,J$1)-SUMIFS($D:$D,$E:$E,$H2,$B:$B,J$1)

另解=SUMPRODUCT(MMULT(N(+$C$2:$D$10),{1;-1})*($B$2:$B$10=J$1)*($E$2:$E$10=$H2))