C
Carolyn
I have subtotals done using the subtotal function. How do I now total those
as a grand total?
as a grand total?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Didn't you get a grand total at the bottom of the data?
C
Carolyn
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.
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.
D
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.
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.
C
Carolyn
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
blank row" data base. In this instance it is easier on the author if I just
do plus, plus and plus...
Carolyn
M
mac@bath
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
use the standard
"=subtotal(9,A1:Axxx)" formula for each column??? I thought that this was
capable of picking up 'nested' sub-total.
--
mac
Carolyn said: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
D
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.
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.