統計進銷總額 依項目名稱 (11477)

M3:M6{=INDEX(C:C,MIN(IF((COUNTIF(M$2:M2,C$3:C$16)=0)*(C$3:C$16>0),ROW($3:$16),99)))&""

N3:O6=IF(M3="","",SUMIF($C:$C,$M3,D:D)+SUMIF($C:$C,$M3,G:G)*(G$2=$H$2))

P3:P6=IF(N3="","",N3-O3)

Q3:R6=IF(M3="","",SUMIFS($G:$G,$C:$C,$M3,D:D,"<>"))