E
Exceller
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.
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.