![]() |
Formula not giving correct answer
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)} |
All times are GMT +1. The time now is 08:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com