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?