summing subtotals

B

BigTim

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?
 
D

Domenic

You can use...

=SUBTOTAL(9,Range)

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

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top