| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totaling subtotals
I have subtotals done using the subtotal function. How do I now total those
as a grand total? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totaling subtotals
Didn't you get a grand total at the bottom of the data?
Carolyn wrote: I have subtotals done using the subtotal function. How do I now total those as a grand total? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totaling subtotals
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" wrote: Didn't you get a grand total at the bottom of the data? Carolyn wrote: I have subtotals done using the subtotal function. How do I now total those as a grand total? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totaling subtotals
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. Carolyn wrote: 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" wrote: Didn't you get a grand total at the bottom of the data? Carolyn wrote: I have subtotals done using the subtotal function. How do I now total those as a grand total? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totaling subtotals
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" wrote: 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. Carolyn wrote: 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" wrote: Didn't you get a grand total at the bottom of the data? Carolyn wrote: I have subtotals done using the subtotal function. How do I now total those as a grand total? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totaling subtotals
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 "Carolyn" wrote: 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" wrote: 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. Carolyn wrote: 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" wrote: Didn't you get a grand total at the bottom of the data? Carolyn wrote: I have subtotals done using the subtotal function. How do I now total those as a grand total? -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totaling subtotals
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. mac@bath wrote: 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 "Carolyn" wrote: 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" wrote: 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. Carolyn wrote: 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" wrote: Didn't you get a grand total at the bottom of the data? Carolyn wrote: I have subtotals done using the subtotal function. How do I now total those as a grand total? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying subtotals | Excel Discussion (Misc queries) | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| Presenting Subtotals only | Excel Discussion (Misc queries) | |||
| Subtotals adding a description next to the subtotals | Excel Worksheet Functions | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Linear Mode
