How to sum values in Google Sheets by category?

By /

Often you may want to sum the values of some dataset in Google Sheets based on a category or group.

For example, suppose we have the following dataset and we’d like to sum the total “points” by team:

The following step-by-step example shows how to do so.

Step 1: Enter the Data

First, enter the data values into Google Sheets:

Step 2: Find the Unique Categories

Next, we need to use the =UNIQUE(Range) function to produce a list of unique values in a certain range.

In our example, this will produce a list of unique teams:

Step 3: Find the Sum by Category

Next, we will use the SUMIF(range, criterion, sum_range) function to find the sum of the points scored by each team:

Sum by category in Google Sheets

This tells us:

  • The total points scored by players on the Lakers is 21.6.
  • The total points scored by players on the Mavericks is 56.4.
  • The total points scored by players on the Spurs is 48.8.
  • The total points scored by players on the Warriors is 65.

x

Related terms:

  1. How to Sum Values by Category in Excel?
  2. Google Sheets: How do I sum across multiple sheets?
  3. Category Test (CT)
  4. BASIC-LEVEL CATEGORY
  5. CATEGORY MIDPOINT
  6. CATEGORY TEST
  7. CATEGORY-SYSTEM METHOD
  8. Count Specific Characters in Google Sheets How to count specific characters in google sheets?
  9. How to Sum If Checkbox is Checked in Google Sheets?
  10. How do I use Google Sheets Query to Sum Multiple Columns?