Does anyone have ideas that would SUM only the subtotal amounts in a
worksheet?

I don't.

But =subtotal() that points at the whole range will ignore the =subtotal() cells
and could give you what you want.

nejohnso76 wrote:

Does anyone have ideas that would SUM only the subtotal amounts in a
worksheet?

--

Dave Peterson

IF you have SUBTOTALs applied automatically, simply use

=SUM(A:A)/2

if you aren't showing the Grandtotal, and use

=SUM(A:A)/3 if you are.

OR, you can use

=SUBTOTAL(9,A:A)

which will sum everything except values in SUBTOTAL formulas...

HTH,
Bernie
MS Excel MVP


"nejohnso76" wrote in message
ups.com...
Does anyone have ideas that would SUM only the subtotal amounts in a
worksheet?

You may want to first update sum formulas to subtotal formulas by
replacing "=sum(" with "=subtotal(9," in the column. Then you could
use:

=SUM(9,A:A)-SUBTOTAL(A:A)

to sum just the subtotal formulas.


nejohnso76 wrote:

Does anyone have ideas that would SUM only the subtotal amounts in a
worksheet?