引用:
原帖由 Guest from 150.96.52.x 于 2016-9-22 11:43 发表 
G3
=IF(RIGHT(F3,3)="滞纳金",SUMPRODUCT(($A$2:$A$977=MID(F3,1,LEN(F3)-4))*($B$2:$B$977="滞纳金")*($C$2:$C$977)),SUMPRODUCT(($A$2:$A$977=F3)*($C$2:$C$977)))
(数组公式，三键结束)
再把公式向下拖
...
上午无仔细看懂楼主要求，现更正7楼
G3
=IF(RIGHT(F3,3)="滞纳金",SUMPRODUCT(($A$2:$A$977=MID(F3,1,LEN(F3)-4))*($B$2:$B$977="滞纳金")*($C$2:$C$977)),SUMPRODUCT(($A$2:$A$977=F3)*($C$2:$C$977))-SUMPRODUCT(($A$2:$A$977=F3)*($B$2:$B$977="滞纳金")*($C$2:$C$977)))
把公式向下拖
统计公式表(1).xls (77 KB)
