excel公式

多条件求和

输入命令为: =SUMIFS(C1:C4,A1:A4,"09-8-1",B1:B4,"张三")

输入命令为: =SUMIFS(求和范围,条件范围1,"09-8-1",条件范围2,"张三")

 

但条件求和

=SUMIF($A$2:$A$13,$A2,$B$2:$B$13)

=SUMIF(条件范围,张三,求和范围)

输入命令为: =SUMIFS(C1:C4,A1:A4,"09-8-1",B1:B4,"张三")