Hi,

If you are using 2007 then try:

=COUNTIFS(A1:A10,"1",A1:A10,"<9")

You can also use

=SUMPRODUCT((A1:A101)*(A1:A10<9))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Roy Ringrose" wrote:

I'm trying to write a formula that will "count" the number of entries in a
list that are greater than one number but less than another.