如果字段为空,则有条件的SUMIF。

时间:2021-09-17 19:19:48

I want to sum the values of column B where column A has a blank field. I have tried the following, but it returns a result of zero

我想把B列的值相加,其中A列有一个空字段。我尝试过以下方法,但它返回的结果是0

=SUMIF(A:A,A:A="",B:B)

I need to reference an entire column, for future expansion on the data. Here is my sample data that i am trying to conditionally sum in EXCEL 2007.

我需要引用整个列,以便将来在数据上进行扩展。这是我试图在EXCEL 2007中有条件地求和的示例数据。

**A      B**
        5.00
        2.00
        2.00
        2.00
ABS004  1.00
AFS001  4.00
AFS001  5.00
AFS001  5.00
AFS001  2.00

1 个解决方案

#1


21  

You shouldn't refer to the column in the criterion - should be just

你不应该引用标准中的列——应该是公正的

=SUMIF(A:A,"",B:B)

#1


21  

You shouldn't refer to the column in the criterion - should be just

你不应该引用标准中的列——应该是公正的

=SUMIF(A:A,"",B:B)