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

subtotals.xlsx (10.4 KB, 11 views)

It's counting the headings you have "MH Count" and "NC Count".

All that grouping looks like a lot of work. Could you get what you want in a pivot table? See attached.

Attached Files

subtotals.xlsx (13.9 KB, 14 views)

Thanks, gebobs.
I thought it might be counting the headings but thought it would also count the "SA Count" which would add 3 instead of 2 to the total.

Thanks for reminding me of the pivot table. You're right about that. I'll have to start using it more.

Yeah, it would have counted the SA Count too but the range of your formula stopped just short of it. Glad I could help.