ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formula not giving correct answer (https://www.excelbanter.com/excel-programming/423512-formula-not-giving-correct-answer.html)

drose

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