=SUMPRODUCT((Info!L5:L499=5)*(Info!L5:L499<=10))

HTH
--
AP

"JohnD" a écrit dans le message de news:
...
I have the following formula in a cell;
=COUNTIF(Info!L5:L499,"5<10")
The criteria of the formula is to check for number between 5 & 10.
How do this.?