Subtotals and Totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a long column with many many subtotals. How do I total the subtotals?
 
You should get a grand total by default if you use data>subtotal
Otherwise use

=SUBTOTAL(9,C2:C200)

where C2:C200 is the full range

--

Regards,

Peo Sjoblom


Allen P. said:
I have a long column with many many subtotals. How do I total the
Click to expand...
subtotals?
 
You must log in or register to reply here.

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

Similar Threads

Average of Subtotals in Pivot Table 0
Subtotal of adjacent coloumn 4
Subtotaling 3
Multiple Subtotal Placement 2
Subtotaling 1
Subtotal 4
Additonal info into newly created Subtotal row 1
how to get totals? 1

Back
Top