=SUMPRODUCT(--(b17:b264.0),--(b17:b26<4.4))
--
Allllen


"sgreene" wrote:

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