第一知识网
www.001rz.comExcel用sum(if 函数两次归类计总
日期:2021-08-06 05:06:28 人气:31
F2
=SUMPRODUCT(($A$2:$A$10=$F$1)*($B$2:$B$10=$E2)*($C$2:$C$10))
G2
=SUMPRODUCT(($A$2:$A$10=$G$1)*($B$2:$B$10=$E2)*($C$2:$C$10))
具体格式见附图,相关范围自己更改,公式可直接向下填充
F2
=SUMPRODUCT(($A$2:$A$10=$F$1)*($B$2:$B$10=$E2)*($C$2:$C$10))
G2
=SUMPRODUCT(($A$2:$A$10=$G$1)*($B$2:$B$10=$E2)*($C$2:$C$10))
具体格式见附图,相关范围自己更改,公式可直接向下填充