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

  • 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

lloyds

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

Attachments

  • My Nonprofit Budget.xlsx
    17 KB · Views: 2
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
 
Back
Top