=COUNTIF(A:A,"10")-COUNTIF(A:A,"20")

will count all items between and including 11-20

--
__________________________________
HTH

Bob

"Kim SACS" <Kim wrote in message
...
How do I use the count if function with the criteria being or < (greater
than or less than) within defined cell that has a single numerical value?

Count if with or < when it has a typed in number works fine. I cant seem
to get it to work when I specify a particular cell.