Select a cell in a clean data table, choose Insert → PivotTable and drag fields into Rows, Columns and Values.
Visual walkthrough
Insert›PivotTable›Rows and Values
Before
The source contains individual project costs.
After
The PivotTable groups and totals the costs.
Check the result
Change one source amount, refresh and compare the total.
Step-by-step instructions
- Use a source table with one header row, no merged cells and numeric cost values. Convert it to an Excel Table with Ctrl+T if suitable.
- Choose Insert → PivotTable, check the source and select New Worksheet.
- Drag Project into Rows, Cost category into Columns and Cost into Values. If Excel shows Count, open Value Field Settings and select Sum after checking the source numbers.
- When source data changes, right-click the PivotTable and choose Refresh. If new rows fall outside a fixed source range, expand the source first.
Frequently asked questions
Can I filter by status?
Yes. Drag Status into Filters, then choose the required status above the PivotTable.
Reference: Microsoft Support