進 銷總額之統計 (11626)

N3:O5=SUMIF($C:$C,$M3,D:D)+SUMIFS($H:$H,$C:$C,$M3,D:D,"<>")

P3:P5=N3-O3

Q3:R5=SUMPRODUCT(($C$3:$C$12=$M3)*D$3:D$12*$F$3:$F$12)