Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-08-2014, 12:44 PM
DavidW DavidW is offline Multi Level Subtotals w 2 Grand Totals That Don't Match Windows XP Multi Level Subtotals w 2 Grand Totals That Don't Match Office 2007
Novice
Multi Level Subtotals w 2 Grand Totals That Don't Match
 
Join Date: Aug 2010
Posts: 3
DavidW is on a distinguished road
Default Multi Level Subtotals w 2 Grand Totals That Don't Match

I'm using Excel 2013.



I have multi level subtotals showing 2 different grand totals. In the attached file, it is first subtotaled on the Diags column. Then it is subtotaled on the County column. The grand total of 29 in the Diags column is correct. The other grand total in the County column is 31. Where did it get the extra 2? I'm also seeing different grand totals on other spreadsheets with multi level subtotals. I know it must be something obvious that I'm not seeing.

Thanks
Attached Files
File Type: xlsx subtotals.xlsx (10.4 KB, 13 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi Level Subtotals w 2 Grand Totals That Don't Match multi-level Paragraph numbering boutells Word 2 08-17-2016 12:18 PM
Multi Level Subtotals w 2 Grand Totals That Don't Match Multi-level lists BeerStud Word 4 08-16-2014 04:00 PM
How 2: Different Styles in Multi-Level List BrianWren Word 1 10-21-2013 08:50 AM
Multi Level Subtotals w 2 Grand Totals That Don't Match Multi-level list styles qochi Word 1 05-31-2011 01:16 AM
Multi Level Subtotals w 2 Grand Totals That Don't Match Headings + Multi-level list falieson Word 1 06-18-2010 12:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft