来源:学生作业帮 编辑:搜狗做题网作业帮 分类:综合作业 时间:2024/06/25 12:45:51
sumif函数求和多条件
![](http://img.wesiedu.com/upload/6/b0/6b07ac06190f78d61441f961d42d66b4.jpg)
以库存为条件,求和差额中大于零的之和,我应该怎么用函数计算呢,
到底是要把库存相加,还是差额相加?
举个例子行不?
再问: 把差额求和,库存大于零的,差额大于零和小于零的,分别求和
再答: 库存大于零的差额求和
=sumif(A:A,">0",B:B)
差额大于零的差额求和
=sumif(A:A,">0")
差额小于零的差额求和
=sumif(A:A,"0",B:B,">0")
库存大于零的前提下,对差额小于零求和
=SUMIFS(B:B,A:A,">0",B:B,"