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)