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