*67*

The **SUMIFS()** function in Google Sheets can be used to sum values that meet criteria in multiple columns.

This function uses the following syntax:

**SUMIFS(sum_range, criteria_range1, criterion1, criteria_range2, criterion2, â€¦)**

where:

**sum_range**: The range of cells to sum.**criteria_range1**: The first range of cells to look at.**criterion1:**The criterion to look for in the first range of cells.

The following example shows how to use this function in practice.

**Example 1: Using SUMIFS with Character Columns in Google Sheets**

Suppose we have the following dataset that shows information for various basketball players:

We can use the following **SUMIFS()** function to sum the points scored by players who are on the Spurs *and* have a Guard position.

The total points scored by players who are on the Spurs *and* have a Guard position is **44**.

**Example 2: Using SUMIFS with Character & Numeric Columns in Google Sheets**

Once again suppose we have the following dataset that shows information for various basketball players:

We can use the following **SUMIFS()** function to sum the points scored by players who are on the Spurs *and* had more than 5 assists:

The total points scored by players who are on the Spurs *and* had more than 5 assists is **70**.

Specifically, we can see that three players met this criteria: Player 1, Player 2, and Player 4.

Combined, they have a total of 31 + 19 + 20 = **70** points.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

How to Use COUNTIF From Another Sheet in Google Sheets

How to Use COUNTIF with Multiple Ranges in Google Sheets

How to Calculate Frequencies in Google Sheets