 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / December 2007Using 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 Maybe... Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default.aspx?scid=kb;en-us;831824 > 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 [quoted text clipped - 17 lines] > Spine Total > 11700 Total  SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.