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