# Google Sheets: How to Sum Values by Category

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:

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.

## 5 Replies to “Google Sheets: How to Sum Values by Category”

1. Richard says:

Thank you very much, the guide helped me a lot!

2. Richard says:

TEST

3. Kelsey says:

What would the formula be if the dataset was on one sheet and you wanted the SUMIF calculations on a different sheet? Also, is it possible to do this if the dataset is compiled using a drop down menu?

I’m compiling a list of preferences for meeting – in person, virtual, both, flexible – and the options are logged using a drop down menu. I want to be able to see how many people chose each option, but I would like the calculations on a different sheet.

4. Still Confused says:

What would you actually put in the sumif function though? This didn’t help me.

5. Larry Groves says:

This tutorial was helpful … just what I needed in a Google sheet.
Thanks, Zach.