Conditional Sum in Range

[Guest]

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.

 

[Bob Phillips]

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

 

[Guest]

It works!
Thanks, Bob, for your valuable help!
Regards,
Exceller