Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotals by grouping
Hello,
I am trying to do a subtotal on a very large worksheet. My problem is that I only need to Subtotal on Changes in categories like Peoples Names and Other categories that are not math related. Is there a way to Subtotal without usung the Sum, Count or any other math Function. I just need the groupings. I looked at the group and outline method but that is done manually. It would also be very tedious to manually delete the Total Rows. Is there another functon onthe subtotals like Var or any others? I am not sure what some of those functions do. Regards chris |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotals by grouping
The DataSubtotal menu option should do what you want, if your data is sorted
by names "Diggsy" wrote: Hello, I am trying to do a subtotal on a very large worksheet. My problem is that I only need to Subtotal on Changes in categories like Peoples Names and Other categories that are not math related. Is there a way to Subtotal without usung the Sum, Count or any other math Function. I just need the groupings. I looked at the group and outline method but that is done manually. It would also be very tedious to manually delete the Total Rows. Is there another functon onthe subtotals like Var or any others? I am not sure what some of those functions do. Regards chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals copy paste | Excel Worksheet Functions | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |