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
|