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?