Conditional Sum in Range
=SUMIF(A2:A20,"",A3:A21)
Note the relationship between the ranges, offset by one row.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Exceller" wrote in message
...
Dear Gurus,
I need a formula that sums subtotals in a range. Here's an example range:
A
1 <formula
2 <header
3 5
4 5
5 10
6
7 5
8 5
9 10
10
I need the formula in A1 to sum every cell in that range that is above a
blank cell (the "blank" cells have formulas in them, but return no
values).
So the formula in cell A1 will return a value of 20, since it sums cells
A5
and A9.
Thank you.
|