Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2-level subtotals?
I have data containing a project number and a project manager number, is
there a way to subtotal it by project, and by manager? Manager-A project-1 total project-2 total project-3 total Manager-A total Manager-B project-4 total project-5 total project-6 total Manager-B total |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2-level subtotals?
Sort firts by anamager then by Project. Now create your first subtotal on
Manager. Now create subtotals again but this time on Project 9change the Subtotal On drop down. The most important thing to do is to uncheck "Replace Current Subtotals". You can nest up to 7 levels of subtotals. -- HTH... Jim Thomlinson "dlw" wrote: I have data containing a project number and a project manager number, is there a way to subtotal it by project, and by manager? Manager-A project-1 total project-2 total project-3 total Manager-A total Manager-B project-4 total project-5 total project-6 total Manager-B total |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2-level subtotals?
Schweet!! Thank you!
"Jim Thomlinson" wrote: Sort firts by anamager then by Project. Now create your first subtotal on Manager. Now create subtotals again but this time on Project 9change the Subtotal On drop down. The most important thing to do is to uncheck "Replace Current Subtotals". You can nest up to 7 levels of subtotals. -- HTH... Jim Thomlinson "dlw" wrote: I have data containing a project number and a project manager number, is there a way to subtotal it by project, and by manager? Manager-A project-1 total project-2 total project-3 total Manager-A total Manager-B project-4 total project-5 total project-6 total Manager-B total |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-Level Subtotals | Excel Discussion (Misc queries) | |||
Create mutli-level subtotals | Excel Worksheet Functions | |||
Subtotals equal zero when collapsed to Level 2 | Excel Discussion (Misc queries) | |||
Multi Level Subtotals and SP2 | Excel Worksheet Functions | |||
multi-level subtotals are in the wrong position | Excel Worksheet Functions |