Excel How-to
How to Create a Pivot Table in Excel (Step by Step)
Build a pivot table in Excel from a sales list, switch Count to Sum, and refresh when rows are added. Includes tested SUMIFS cross-checks and GETPIVOTDATA formulas that also work in Google Sheets.