# Google Sheets Query: How to Use the SUM Function

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.

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

May 29, 2024
May 13, 2024
April 25, 2024

## One Reply to “Google Sheets Query: How to Use the SUM Function”

1. Luciano says:

hello! how can i change the name to the column? for example from “sum Rebounds” to “Mavs Rebounds”