R
Rusty
How do I sum a cloumn of numbers when my reference column is blank?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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)
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)
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)