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) |
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) |
All times are GMT +1. The time now is 07:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com