文章分类 -  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(条件 阅读全文