*53*

You can use the **SUM() **function in a Google Sheets query to find the sum of values in rows that meet certain conditions.

**Method 1: Sum All Rows**

=QUERY(A1:C13, "select sum(C)")

**Method 2: Sum Rows that Meet One Criteria**

=QUERY(A1:C13, "select sum(C) where B>100")

**Method 3: Sum Rows that Meet Multiple Criteria**

=QUERY(A1:C13, "select sum(C) where A='Mavs' OR B>100") =QUERY(A1:C13, "select sum(C) where A='Mavs' AND B>100")

The following examples show how to use each of these methods in practice.

**Method 1: Sum All Rows**

We can use the following formula to sum the total points scored by all teams:

We can see that the teams scored a total of **1,141** points.

**Example 2: Sum Rows that Meet One Criteria**

We can use the following formula to sum the total points scored by teams who had less than 30 rebounds:

The total points scored by teams who had less than 30 rebounds was **679**.

**Example 3: ****Sum Rows that Meet Multiple Criteria**

We can use the following formula to sum the total rebounds by teams where the team name is equal to “Mavs” or where the points is greater than 100:

The sum of the rebounds among teams that meet either of these criteria is **84**.

**Additional Resources**

The following tutorials explain how to perform other common operations with Google Sheets queries:

Google Sheets Query: Select Rows that Contain String

Google Sheets Query: How to Use Group By

Google Sheets Query: How to Use Order By

Google Sheets Query: How to Use the COUNT Function