Allllen,
Tried your formula...4 rows of numbers on top are what they should be...4
numbers on the bottom are what they come out with your formula. Some are
correct and some are not??? Can you suggest anything. I truly appreciate
your help.

4 5 0 0 10 3
6 3 3 0 0 5
0 2 4 2 0 2
0 0 3 8 0 0


4 5 0 0 10 3
4 3 1 0 0 1
0 2 4 2 0 2
0 0 3 8 0 0


"Allllen" wrote:

=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