Totaling subtotals

[Guest]

I have subtotals done using the subtotal function. How do I now total those
as a grand total?

 

[Dave Peterson]

Didn't you get a grand total at the bottom of the data?

 

[Guest]

No. But I think your question is the answer. This is not set up as a true
data base. There are rows between each row with data in it. The author
wanted the extra set of gridlines between the rows of data.

I think you have helped me before. Thanks so much for all your help.

 

[Dave Peterson]

If you could edit the data, the first thing I would do is remove those blank
rows--and remove the subtotals that were inserted manually (if there are any).

Then use Data|subtotals to get the subtotals.

If you can do this, maybe you could just sort the data and the blank rows should
be grouped together and then you can just delete them in one go.

If you can't do that, maybe you can use data|filter|autofilter and filter to
just show the rows that should be deleted. Then delete those visible rows.

 

[Guest]

I wish I could do all this. But there are many who don't understand the "no
blank row" data base. In this instance it is easier on the author if I just
do plus, plus and plus...

Carolyn

 

[Guest]

Sorry if I've missed something here, but I can't understand why can you not
use the standard
"=subtotal(9,A1:Axxx)" formula for each column??? I thought that this was
capable of picking up 'nested' sub-total.
--
mac

I wish I could do all this. But there are many who don't understand the "no
blank row" data base. In this instance it is easier on the author if I just
do plus, plus and plus...

Carolyn

 

[Dave Peterson]

It won't include other =subtotal() formulas.

But if the worksheet is like a lot that I've seen, the users have manually added
the blank row and also manually added formulas like =sum()--and =subtotal()
won't ignore those.