If it's a continuous range so as [5,10), you can get there by counting those
five or greater and subtracting the count of those greater than or equal to
10:
=countif(a1:a30,"=5")-countif(a1:a30,"=10")

"iMartyn" wrote:

I want to check a range of numeric values and count the number that are
between 5 and 10 say. I've tried "=COUNTIF(A1:A30, "5 and <10") but
doesn't seem to work.
Can this be done ?

PS -I'm aware I could count each single value (eg 5, 6, 7, 8, 9, 10) and
then sum separately, but looking for a neater way to do it.

Thanks
iMartyn