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?