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.

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

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

"Bob Phillips" wrote:

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