Try

=SUMPRODUCT((MONTH(D6:D8)=MONTH(NOW())-1)*(E6:E8<8))

Mike

"drose" wrote:

If D6= 1/25/2009, D7= 1/27/2009, and D8= 1/30/2009
E6= 2, E7=16, E8= 5 the formula below is giving me (0).
I would like to know the how many are less than 8 for january.
The answer would be (2). Does anyone know where I have messed up?
Thanks

{=SUMPRODUCT(MONTH(D6:D8)=MONTH(TODAY())-1,E6:E8<8)}