I need to sum the subtotals in a field, and it appears the best way to do it
is to add all of the cells that are above a blank cell. For example:

A
1 <FORMULA
2 <heading
3 5
4 7
5 12
6
7 2
8 3
9 5
10

The subtotals are in rows 5 and 9. I need to sum those (and all other
subtotals in this field) in cell A1. It looks like the best way to do this
would be to condition the formula to sum all cells above the blank cells
(cells A5 and A9--and all other cells above blanks).
How would I do this? I searched for an example of this on the web and in
this forum but haven't found anything on it.

Thanks you.