Counting up a range of figures, e.g. 10.0-10.999

Morning,

Any help given will be appreciated. I usually use the formula =countif(A2-A999,"10") if I want to count up the number of times 10 is in column A.

However I'm not sure how to adapt it so it will count up every time a number between 10 and 10.999 is in column A.

Thanks for any help you an give.

Regards

1. Numbers shouldn't need to be within double quotes so =countif(A2:A999,10) should suffice for a normal COUNTIF

2. A2-A999 is not a valid range, it should be A2:A999

3. Since you need > and < it will need to be in double quotes

=countifs(A2:A999,">=10",A2:A999,"<=10.999")