| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Using Subtotals
I need help with a spreadsheet created by someone else that includes subtotal
levels. The subtotals/totals feature works well until I get to an organization that has several cost center numbers (CTR). It does not total all of the cost centers together for one organization. Instead it totals all but the last CTR and places its total beneath the grand total for the ORG. Any ideas? Thanks so much! ORG CTR ACCT NAME REG HR OT HR Spine 11500 Spine 11500 Spine 11500 11500 Total Spine 11550 Spine 11550 11500 Total Spine 11700 Spine 11700 Spine 11700 Spine 11700 Spine Total 11700 Total |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Using Subtotals
Maybe...
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 Sue wrote: I need help with a spreadsheet created by someone else that includes subtotal levels. The subtotals/totals feature works well until I get to an organization that has several cost center numbers (CTR). It does not total all of the cost centers together for one organization. Instead it totals all but the last CTR and places its total beneath the grand total for the ORG. Any ideas? Thanks so much! ORG CTR ACCT NAME REG HR OT HR Spine 11500 Spine 11500 Spine 11500 11500 Total Spine 11550 Spine 11550 11500 Total Spine 11700 Spine 11700 Spine 11700 Spine 11700 Spine Total 11700 Total -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Linear Mode
