You can use the following formula to count the number of cells in Excel that are greater than but less than some number:
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:
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.
The following tutorials explain how to perform other common tasks in Excel: