# Google Sheets Query: How to Use the COUNT Function

You can use the COUNT() function in a Google Sheets query to count the number of rows that meet certain conditions.

Method 1: Count Total Rows

=QUERY(A1:C13, "select count(A)")

Method 2: Count Total Rows that Meet One Criteria

=QUERY(A1:C13, "select count(A) where B>100")

Method 3: Count Total Rows that Meet Multiple Criteria

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

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

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

### Method 1: Count Total Rows

We can use the following formula to count the total number of teams:

We can see that there are 12 total teams.

### Example 2: Count Total Rows that Meet One Criteria

We can use the following formula to count the total number of teams where the points is greater than 100:

We can see that there are 2 teams that have over 100 points.

We can use the following formula to count the total number of teams that have less than 100 points:

We can see that 10 teams have less than 100 points.

### Example 3: Count Total Rows that Meet Multiple Criteria

We can use the following formula to count the total number of teams where the team name is “Mavs” or where the points is greater than 100:

We can see that 3 teams meet either of these criteria.

We can use the following formula to count the total number of teams where the points is greater than 90 and the rebounds is greater than 30:

We can see that 2 teams meet both of these criteria.

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

May 13, 2024
April 25, 2024
April 19, 2024
April 18, 2024

## 3 Replies to “Google Sheets Query: How to Use the COUNT Function”

1. MM says:

HOW CAN I GET RID OF THE “COUNT” HEADER

2. david says:

Why it doesn’t work ? The function is returning “count”.

3. Alvin B. says:

How to get rid of the useless header row that says “count” and ONLY return the number would be very useful information. Sheets completely ignores the header value when using count and continually tells you that you’re counting in an extra useless row.