Google Sheets: How to Count Cells Between Two Values


You can use the following basic syntax to count the number of cells between two values in Google Sheets:

=COUNTIFS(A:A,">10",A:A,"<15")

This particular formula counts the number of cells in column A that are greater than 10 or less than 15.

The following example shows how to use this syntax in practice.

Example: Count Cells Between Two Values in Google Sheets

Suppose we have the following data in Google Sheets:

We can use the following formula to count the number of cells in column B that have a value greater than 10 and less than 20:

=COUNTIFS(B:B,">10",B:B,"<20")

The following screenshot shows how to use this formula in practice:

There are 4 points values that are greater than 10 and less than 20.

We can manually count each of these four values in column B:

Note that we can also use >= and <= in the formula to count the values between 10 and 20, inclusive:

=COUNTIFS(B:B,">=10",B:B,"<=20")

The following screenshot shows how to use this formula in practice:

There are 6 points values that are greater than or equal to 10 and less than or equal to 20.

We can manually count each of these six values in column B:

Note: You can find the complete documentation for the COUNTIFS function in Google Sheets here.

Additional Resources

The following tutorials explain how to perform other common COUNTIF() operations in Google Sheets:

How to Use COUNTIFS with a Date Range in Google Sheets
How to Use COUNTIF with OR in Google Sheets
How to Use COUNTIF From Another Sheet in Google Sheets
How to Use COUNTIF with Multiple Ranges in Google Sheets

Leave a Reply

Your email address will not be published.