Calculate Average Scores By Category using Google Sheets Pivot Table
February 2, 2025 • Google Sheets • Published By Josh • 2 minute read
During player evaluations for a sports organization, each player is evaluated across multiple categories. The scores must be averaged and totaled. This data is then used to make decisions for the following sports season. Let’s learn how to calculate the average scores by category using a pivot table in Google Sheets!
Table of Contents
Spreadsheet Setup
Let’s say we have a sheet of data that has three columns:
- Name
- Category
- Score
There are multiple rows of data with duplicate names and categories. We want to calculate the average score per player name and category. We can do this with a Pivot Table!
Pivot Table
To create a Pivot Table in Google Sheets, navigate to Insert > Pivot Table. At the Data range field, select all columns and rows of data, including the column headings. At the Insert to field, choose New sheet, which will create the pivot table in a new sheet. Select Create.
In the Pivot table editor, we need to select which pieces of data will go where. For the Rows, we want Name, which will create a row per unique player. You can also decide the sort order. For the Columns, we want Category, which will create a column per unique category. You can also decide the sort order. For the Values, we want Score, and choose AVERAGE under the Summarize by field.
The result is a nicely formatted report of average scores by player name and category, including grand totals!
Related Articles
