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