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