PivotTable Values: Sum, Count, Average
A PivotTable can summarise the same number in different ways: Sum (the default for numbers), Count (how many rows), Average, Max, Min. In the field settings choose Summarize Values By.
Each choice matches a function: SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS. The same group can be shown several ways side by side, which often tells a fuller story than the sum alone.
Exampleexcel
Quick check
Which PivotTable setting shows how many rows are in each group?
Your turn: write the code
Show the average price for each group in G2:G3 with AVERAGEIFS.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.