You can use the following formula to count the number of cells in Excel that are greater than but less than some number:
=COUNTIFS(B:B,">15",B:B,"
This particular formula counts the number of cells in column B 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 Excel 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 column that have a value greater than 15 but less than 25:
=COUNTIFS(B2:B11,">15",B2:B11,"
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 Excel here.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
COUNTIF vs. COUNTIFS in Excel: What’s the Difference?
How to Use COUNTIF with OR in Excel
How to Use COUNTIF From Another Sheet in Excel