导读 用数组求和公式:假设原数据在sheet1,汇总数据在sheet2,sheet2的B2:=SUM(IF((Sheet1!$A$2:$A$7=$A2)*(Sheet1!$C$2:$C$7="人为"),1,0))C2:=SU...
用数组求和公式:假设原数据在sheet1,汇总数据在sheet2,sheet2的B2:=SUM(IF((Sheet1!$A$2:$A$7=$A2)*(Sheet1!$C$2:$C$7="人为"),1,0))C2:=SUM(IF((Sheet1!$A$2:$A$7=$A2)*(Sheet1!$C$2:$C$7="非人为"),1,0))D2:=B2+C2其中B2,C2输入后按ctrl+shift+enter录入公式,此时出现{}B3,C3,D3及以后的就拖着第2行的单元格向下复制就可以了.另外也可以用数据透视表实现.。