Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals
I created a grand totals row using autosum and saved it in a macro. My
problem is that when I use the macro on table of different sizes, the grand totals are always created on the same row number. Is there another way to get grand totals without using subtotals? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals
When using Data | Subtotals you have to specify "For each change in
"... column xyz. Instead, you can obtain a unique list of all the values in that column (easily done with Advanced Filters, and usually better placed in a different sheet), then you can use SUMIF formulae to summarise the data in a separate table. More complex summaries can be obtained using SUMPRODUCT formulae, or array formulae along the lines of SUM(IF( ... I find this far more useful than the in-built sub-totalling feature. Hope this helps. Pete On Mar 12, 1:08*am, Elzora wrote: I created a grand totals row using autosum and saved it in a macro. *My problem is that when I use the macro on table of different sizes, the grand totals are always created on the same row number. *Is there another way to get grand totals without using subtotals? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals
Have you tried pivot tables? Can be tedious but as the original table gets
updated so does the result table - totals. "Elzora" wrote: I created a grand totals row using autosum and saved it in a macro. My problem is that when I use the macro on table of different sizes, the grand totals are always created on the same row number. Is there another way to get grand totals without using subtotals? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grand Totals
it might be helpful to post your code.
Regards FSt1 "Elzora" wrote: I created a grand totals row using autosum and saved it in a macro. My problem is that when I use the macro on table of different sizes, the grand totals are always created on the same row number. Is there another way to get grand totals without using subtotals? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Grand Totals with Nested Sub Totals | Excel Discussion (Misc queries) | |||
Grand totals on another worksheet. | Excel Worksheet Functions | |||
More Grand Totals | Excel Worksheet Functions | |||
Grand Totals @ Same Place | Excel Worksheet Functions |