I'm trying to build a formula which will count the amount of entries that match 2 criteria, the first that matches a month and the second which states either "Late" or "OK".
I get an #NAME? message when I use this formula =SUMPRODUCT(($C$2:$C$200=Late)*($D$2:$D$200=(MONTH($D$2:$D$200)=11)))
Can anyone help please
Bookmarks