EXCEL求和?
“=SUMIF($A$2:$A$7,A2,$B$2:$B$6)”适于单条件求和。
“=SUMPRODUCT(($A$2:$A$7=A2)*($B$2:$B$7=B2)*$C$2:$C$7)”适于多条件求和。
“{=SUM(IF($A$2:$A$7=A3,IF($B$2:$B$7=B3,$C$2:$C$7)))}”适于多条件求和。
。
“=SUMIF($A$2:$A$7,A2,$B$2:$B$6)”适于单条件求和。
“=SUMPRODUCT(($A$2:$A$7=A2)*($B$2:$B$7=B2)*$C$2:$C$7)”适于多条件求和。
“{=SUM(IF($A$2:$A$7=A3,IF($B$2:$B$7=B3,$C$2:$C$7)))}”适于多条件求和。
。收起