summing subtotals
 

I have a column of numbers. It consists of values, and at the top of each
section is a subtotal of the below section. I want to sum only the
subtotals, so I can select the entire column for the grand total.

How do I do that without killing my existing format?

column C
grand total

subtotal a
value a1
value a2
value a3
subtotal b
value b1
value b2
value b3
etc....

I want to only sum the subtotals and have that number in the grandtotal.

When I try to use the subtotal function it totally disrupts my formatting
and puts into a structure I can't use.

any ideas?

You can use...

=SUBTOTAL(9,Range)

....which will ignore nested subtotals and avoid double counting.

Hope this helps!

In article ,
BigTim wrote:

I have a column of numbers. It consists of values, and at the top of each
section is a subtotal of the below section. I want to sum only the
subtotals, so I can select the entire column for the grand total.

How do I do that without killing my existing format?

column C
grand total

subtotal a
value a1
value a2
value a3
subtotal b
value b1
value b2
value b3
etc....

I want to only sum the subtotals and have that number in the grandtotal.

When I try to use the subtotal function it totally disrupts my formatting
and puts into a structure I can't use.

any ideas?