Thread: [Solved] Multi Level Subtotals w 2 Grand Totals That Don't Match
View Single Post
 
Old 10-08-2014, 12:44 PM
DavidW DavidW is offline Windows XP Office 2007
Novice
  
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