If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|