If you really only have 2 cells that are between 10 and 20, inclusive,
then all three of the formulae I gave you will return 2.




In article ,
"bsantona" wrote:

still not working correctly. I have 12 cells that have data, of the 12 cells
2 have the data range between 10 - 20 so I'm looking for the formula to give
me a count of 2 but the formulas below give me a count of 10 which makes
sense since it's subtracting.