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.