用函数如何实现表中求和？

愿如初

请大神帮忙教教，用函数如何实现表中求和？
如何实现.rar (10.1 KB, 下载次数: 13)

2021-12-16 15:23 上传

点击文件名下载附件
如何实现.rar

吃肉的兔子

=SUMIFS(B:B,A:A,G4,C:C,">0",D:D,">0",E:E,">0")

五溪舟

=SUMIFS(B:B,A:A,"="&G4,C:C,"<>0",D:D,"<>0",E:E,"<>0")

远东豹

SUMPRODUCT(($A$4:$A$43=G4)*($C$4:$C$43<>0)*($D$4:$D$43<>0)*($E$4:$E$43<>0)*$B$4:$B$43)

新力机械

=SUMPRODUCT(($A$4:$A$43=G4)*($C$4:$C$43<>0)*($D$4:$D$43<>0)*($E$4:$E$43<>0)*$B$4:$B$43)