Question: I need a formula to count the number of cells in a range that are between 10 and 10.000:

I have: 

```
=COUNTIF(B2:B292,>10 AND <10.000) 

```

But how do I put the comparison operators in without getting a formula error?

Answer: 
Example-

For cells containing the values between 21-31, the formula is:

```
=COUNTIF(M$7:M$83,">21")-COUNTIF(M$7:M$83,">31")

```
=COUNTIFS(H5:H21000,">=100", H5:H21000,"<999")