Google Sheets: COUNTIF Greater Than But Less Than Some Number

By /

You can use the following formula to count the number of cells in Google Sheets that are greater than but less than some number:

=COUNTIFS(B2:B11,">15",B2:B11,"<25")

This particular formula counts the number of cells in the range B2:B11 where the value is greater than 15 but less than 25.

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

Example: COUNTIF Greater Than But Less Than

Suppose we have the following dataset in Google Sheets that shows the number of points scored by basketball players on various teams:

We can use the following formula to count the number of cells in the Points column that have a value greater than 15 but less than 25:

=COUNTIFS(B2:B11,">15",B2:B11,"<25")

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

We can see that a total of 3 cells in the Points column have a value greater than 15 but less than 25.

We can verify this is correct by manually identifying each of these cells in the data:

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

x

Related terms:

  1. How to use Google Sheets: COUNTIF Greater Than Zero
  2. How do I sum a column if the value in that column is less than a given value?
  3. Excel Formula: If Greater Than But Less Than
  4. How to Use Greater Than & Less Than in MongoDB Queries
  5. How to VBA: Countif Greater than Date
  6. How to use greater than or equal to in Google Sheets IF Function
  7. Google Sheets: Use Case Sensitive COUNTIF
  8. How to Use COUNTIF Contains in Google Sheets?
  9. How do you Use COUNTIF with Wildcards in Google Sheets?
  10. How to use COUNTIF with OR in Google Sheets?