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