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: 
If you have Excel 2007 or later use `COUNTIFS` with an "S" on the end, i.e.

`=COUNTIFS(B2:B292,">10",B2:B292,"<10000")`

You may need to change commas , to semi-colons ;

In earlier versions of excel use `SUMPRODUCT` like this

`=SUMPRODUCT((B2:B292>10)*(B2:B292<10000))`

Note: if you want to include exactly 10 change > to >= - similarly with 10000, change < to <=
=COUNTIFS(H5:H21000,">=100", H5:H21000,"<999")