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,"<25")

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,"<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.

**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