Formula not giving correct answer

D

drose

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)}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move cells down to match cells 0
Move cells down to match cells 0
Move cells down to match cells 3
Move to match cells 0
Move to match cells 0
Move to match cells 0
Move to match cells 0
Move to match cells 0

Top