Menu
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
=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.
**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
623
Using Excel SUMIF function you can sum the numbers from a range of cells that meet the criteria based on cells that do not contain any value (Blank) or cells that are contain a value (Not Blank).
We can use the SUMIFS Function to sum all Scores for Players without names in the example below. We use double quotes (“”) to represent a blank cell in Excel. Our example ignores Players A, B, C, and D and sums the scores for unknown Players.
Sometimes you need to check if a cell is blank, generally because you might not want a formula to display a result without input. In this case we're using IF with the ISBLANK function: =IF(ISBLANK(D2),"Blank","Not Blank")
You shouldn't refer to the column in the criterion - should be just
=SUMIF(A:A,"",B:B)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
