Table of Contents
Google Sheets allows users to use the SUMIF function to add up the values in one column based on criteria from another column. This function can be extended to also include multiple columns, by specifying additional criteria from other columns. This can be useful for finding the sum of values in a table that meet multiple conditions. For example, you can use SUMIF to find the sum of all values in one column where the corresponding values in two other columns are equal to certain criteria.
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:
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.
The following tutorials explain how to perform other common operations in Google Sheets: