How do I count cells that are between two numbers in Excel?
I need a formula to count the number of cells in a range that are between 10 and 10.000:
=COUNTIF(B2:B292,>10 AND <10.000)
But how do I put the comparison operators in without getting a formula error?
If you have Excel 2007 or later use COUNTIFS with an "S" on the end, i.e.
You may need to change commas , to semi-colons ;
In earlier versions of excel use SUMPRODUCT like this
Note: if you want to include exactly 10 change > to >= - similarly with 10000, change < to <=