How to Sum a column if reference column is blank

  • Thread starter Thread starter Rusty
  • Start date Start date
when my reference column is blank?

What does that mean?
--
Mike

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''''s razor (Abbrev)
 
See if this is what you had in mind...

96...x
51.....
22...p
73.....
81.....

Sum A1:A5 where the corresponding cell in B1:B5 is blank/empty:

=SUMIF(B1:B5,"",A1:A5)

Result = 205 (51+73+81)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the non blank cells 1
SUMIF with criteria "<>" & "=" 4
Sum the last 5 numbers in a column 6
Zero and Null Sum Function 2
Sum Values from different column 1
Sum if not blank 2
Counting blanks as zeros 1
Multiple SUM's in a column 15

Back
Top