Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
simultaneous subtotals
I have a list of course rosters. I want to view subtotals of the following
information for each course section: Total number of students Gender percentages Ethnicity percentages Is there a way to subtotal the data so that it shows me all three things in fields after each course section? (like what it does when you do a simple subtotal) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
simultaneous subtotals
You can perform multiple subtotals on different columns of a list by
unchecking the box next to the Replace Current Subtotals line in the Subtotals menu. Make sure you think out how you want the subtotals laid out for each section, because you can get into trouble counting and summing one of the other subtotal lines. "johnny vino" wrote: I have a list of course rosters. I want to view subtotals of the following information for each course section: Total number of students Gender percentages Ethnicity percentages Is there a way to subtotal the data so that it shows me all three things in fields after each course section? (like what it does when you do a simple subtotal) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) |