How to Sum a column if reference column is blank
 

How do I sum a cloumn of numbers when my reference column is blank?

How to Sum a column if reference column is blank
 

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)


"Rusty" wrote:

How do I sum a cloumn of numbers when my reference column is blank?

How to Sum a column if reference column is blank
 

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)

--
Biff
Microsoft Excel MVP


"Rusty" wrote in message
...
How do I sum a cloumn of numbers when my reference column is blank?