Bob, thank you, but couldn't get it to work at all.

"Bob Phillips" wrote:

=COUNTIF(B17:B264)-COUNTIF(B17:B26=4.4)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"sgreene" wrote in message
...
I need to do a formula and have had no luck.
Need to do a countif for b17:b26 but I also need to in that list if there
are numbers <4.4 and 4.0
Any formula I have tried does not work.
Thanks