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.

We can use a **SUMIFS** function to do this since we’re using multiple criteria when calculating the sum:

=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**.

**Additional Resources**

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

Google Sheets: How to Use COUNTIF with Multiple Ranges

Google Sheets: How to Use SUMIF with Multiple Columns

Google Sheets: How to Sum Cells If Not Blank