How to Sum a column if reference column is blank

M

Mike H

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)
 
T

T. Valko

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

Footer text appears "squished" 1
Publisher adding blank page when printing my booklet... 2
Two columns followed by single page-width column on same page 0
SUMIF with criteria "<>" & "=" 4
Blank pages 0
Sum Values from different column 1
How to center adjust text above and image in a two column document. 1
Sum above columns until non-numeric encountered 1

Top