求EXCLE条件分类计数公式.
来源:学生作业帮 编辑:百度作业网作业帮 分类:综合作业 时间:2024/07/15 15:25:18
求EXCLE条件分类计数公式.
表一
表二
在表二中显示表一里面二月减去一月后的销量的情况.例如 表一中甲的二月4个销量都大于1月,
那么在表二中显示4
数组公式,按三键结束,数据区域自己调整
=SUM(IF($A$2:$A$17=$A22,IF($C$2:$C$17-$B$2:$B$17>0,1,0)))
=SUM(IF($A$2:$A$17=$A22,IF($C$2:$C$17-$B$2:$B$17=0,1,0)))
=SUM(IF($A$2:$A$17=$A22,IF($C$2:$C$17-$B$2:$B$17<0,1,0)))
再问: 谢谢你的答案,请问如果用sumproduct函数该怎么写。
再答: =SUMPRODUCT(($A$2:$A$17=$A22)*($C$2:$C$17-$B$2:$B$17>0)) =SUMPRODUCT(($A$2:$A$17=$A22)*($C$2:$C$17-$B$2:$B$17=0)) =SUMPRODUCT(($A$2:$A$17=$A22)*($C$2:$C$17-$B$2:$B$17
=SUM(IF($A$2:$A$17=$A22,IF($C$2:$C$17-$B$2:$B$17>0,1,0)))
=SUM(IF($A$2:$A$17=$A22,IF($C$2:$C$17-$B$2:$B$17=0,1,0)))
=SUM(IF($A$2:$A$17=$A22,IF($C$2:$C$17-$B$2:$B$17<0,1,0)))
再问: 谢谢你的答案,请问如果用sumproduct函数该怎么写。
再答: =SUMPRODUCT(($A$2:$A$17=$A22)*($C$2:$C$17-$B$2:$B$17>0)) =SUMPRODUCT(($A$2:$A$17=$A22)*($C$2:$C$17-$B$2:$B$17=0)) =SUMPRODUCT(($A$2:$A$17=$A22)*($C$2:$C$17-$B$2:$B$17