# Google Sheets: How to Count Cells Between Two Values

You can use the following basic syntax to count the number of cells between two values in Google Sheets:

```=COUNTIFS(A:A,">10",A:A,"<15")
```

This particular formula counts the number of cells in column A that are greater than 10 or less than 15.

The following example shows how to use this syntax in practice.

### Example: Count Cells Between Two Values in Google Sheets

Suppose we have the following data in Google Sheets:

We can use the following formula to count the number of cells in column B that have a value greater than 10 and less than 20:

`=COUNTIFS(B:B,">10",B:B,"<20")`

The following screenshot shows how to use this formula in practice:

There are 4 points values that are greater than 10 and less than 20.

We can manually count each of these four values in column B:

Note that we can also use >= and <= in the formula to count the values between 10 and 20, inclusive:

`=COUNTIFS(B:B,">=10",B:B,"<=20")`

The following screenshot shows how to use this formula in practice:

There are 6 points values that are greater than or equal to 10 and less than or equal to 20.

We can manually count each of these six values in column B:

Note: You can find the complete documentation for the COUNTIFS function in Google Sheets here.