Countif will only take one criterion. But if you just want a range, you
could count everything =1 and subtract everything 10. What's left will be
the number in your range.
=countif(a1:a100,"=1")-countif(a1:a100,"10")

"HJ" wrote:

I'm trying to add a formula that will count the number of occurences between
two criteria. How do you add another criteria to this formula?

countif(a1:a100,"=1") I would also like to say and less than or equal to 10.

Any suggestions or is there another function that would work better?

TIA