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