函数负数汇总

无上菩提

帮忙用函数加条件只求负数汇总，谢谢
008.zip (8.18 KB, 下载次数: 199)

2021-12-16 08:30 上传

点击文件名下载附件
008.zip

相爱到世界尽头

比如：=SUMIFS(C:C,C:C,"<0",B:B,"把手")

舌头

=SUMIFS($C$2:$C$35,$B$2:$B$35,"把手",$C$2:$C$35,"<0")

=SUMIFS($C$2:$C$35,$B$2:$B$35,"面板",$C$2:$C$35,"<0")

老男

数为0，是不是我哪里出问题了

忆诚

=SUM(($B$2:$B$35="把手")*($C$2:$C$35<0)*($C$2:$C$35))
=SUM(($B$2:$B$35="面板")*($C$2:$C$35<0)*($C$2:$C$35))数组函数，输入后需ctrl+shift+enter结束

潜艇

=SUMIFS(C2:C35,C2:C35,"<0",B2:B35,"把手")

丽人国际

=SUM(-TEXT((B2:B35="把手")*C2:D35,"!0;0;0"))

老王吉祥

把手欠量： =SUMPRODUCT(($B$2:$B$35="把手")*($C$2:$C$35<0)*$C$2:$C$35)                 面板欠量：=SUMPRODUCT(($B$2:$B$35="面板")*($C$2:$C$35<0)*$C$2:$C$35)

玉遇有缘人

C37=SUMPRODUCT((LEFT($A37,2)=$B$2:$B$35)*($C$2:$C$35<0)*$C$2:$C$35)