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. lloyds

    lloyds New 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.

    Attached Files:

  2. Chihiro

    Chihiro Well-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.

    upload_2017-7-17_15-43-42.png
    Thomas Kuriakose likes this.

Share This Page