Table of Contents
The SUMIF function can be used to add up values from another sheet in Google Sheets. To do this, you must use the syntax: SUMIF(Sheet1!Range,Criteria,Sheet2!Range). The Sheet1!Range is the of the sheet you want to sum, the Criteria is the criteria for selecting the data you want to add, and the Sheet2!Range is the range of cells you want to sum in the other sheet.
You can use the following basic syntax to use a SUMIF from another sheet in Google Sheets:
=SUMIF(Sheet1!B2:B11, ">10")
This particular formula takes the sum of values in the range B2:B11 on the sheet titled Sheet1 only if the values are greater than 10.
The following examples show how to use this syntax in practice.
Example 1: SUMIF From Another Sheet
Suppose we have the following sheet named Sheet1 in Google Sheets that contains some data about basketball players:
Now suppose we’d like to switch to Sheet2 and take the sum of the points for the players who have more than 10 points.
We can use the following syntax to do so:
=SUMIF(Sheet1!B2:B11, ">10")
Here’s how to apply this formula in practice:
We can see that the sum of the points values for players who scored more than 10 points is 41.
Example 2: SUMIFS From Another Sheet
Suppose we have the following sheet that contains some data about basketball players:
Now suppose we’d like to switch to Sheet2 and take the sum of the points values for the players who are on team A and have less than 10 points.
=SUMIFS(Sheet1!B2:B11, Sheet1!A2:A11, "A", Sheet1!B2:B11, "<10")
Here’s how to apply this formula in practice:
We see that the sum of points scored among players on team A who had less than 10 points is 22.