Home » Google Sheets: How to Use SUMIF with Multiple Columns

Google Sheets: How to Use SUMIF with Multiple Columns

by Tutor Aspire

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

You may also like