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 here.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Google Sheets: How to COUNTIF Not Equal to Text
Google Sheets: How to Use COUNTIF Contains
Google Sheets: How to Use COUNTIF with Wildcards
