Count how many times a value appears in a year and month

[matrixpom]

Hi all,
Trying to get a formula to calculate how many times the word "NO" appears in a particular year and month, Column "A" being a series of dates going back three years, column "B" will have the word "YES" or " NO", I can calculate the amount of rows in a particular year and month but struggling with the third criteria "NO", this is what I have so far, "C1" holds the month number & "D1" the year:

Please Login or Register  to view this content.

Any ideas? As always, greatly appreciate any help guys - Marc

[FDibbins]

Try using countifS() instead?

something like...
=countifs($A$2:$A$10000,">=1/1/2021,$A$2:$A$10000,"<=1/31/2021,$B$2:$B$10000,"NO")

Instead of hard coding the dates, you could put them in cells and reference them

[bebo021999]

=SUMPRODUCT((MONTH($A$2:$A$10000)=C1)*(YEAR($A$2:$A$10000)=D1)*($B$2:$B$10000="NO"))

Or

=SUMPRODUCT((TEXT($A$2:$A$10000,"m-yyyy")=C1&"-"&D1)*($B$2:$B$10000="NO"))

[matrixpom]

Thanks again guys for your assistance, bebo your last option works perfect, thanks again for your help mate! Have a great day gents - Marc