1. ### Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo
2. Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

# Grand Total when using Data>Subtotal from Ribbon is incorrect

Discussion in 'Ask an Excel Question' started by lloyds, Jul 17, 2017.

1. ### lloydsNew Member

Messages:
1
For a budget spreadsheet, I'm using the Subtotal tool on the Data tab to automatically create subtotals for different categories (at each change in Category) such as
Supplies and Services Total
Building Expenses Total
Salaries and Benefits Total
Those totals are all correct. However, the Grand Total at the bottom includes the subtotals AND the detailed costs so it's wrong.

File size:
17 KB
Views:
2
2. ### ChihiroWell-Known Member

Messages:
3,577
On my end it's showing correct result (ignoring Subtotal cells).
\$262,400.00

You can check using =SUMIF(A2:A35,"<>*Total",C2:C35)

Which gives same amount.

If you use =SUM(C2:C35) it gives \$524,800.00.
Which is sum of all cells, including subtotals.

Thomas Kuriakose likes this.