SUMPRODUCT with one additional criterion

[virtuosok]

Hi,
I have the following working formula:

=SUMPRODUCT((--(IFERROR(MONTH('IWR3'!$N$2:$N$1000),0)=8)),--(IFERROR(YEAR('IWR3'!$N$2:$N$1000),0)=2021))

How can I add another condition? Namely, making sure that formula only counts instances with particular word in column J?
I.e. 'IWR3'!$J$2:$J$1000="Word"

 

[maabadi]

How about:

=SUMPRODUCT((--(IFERROR(MONTH('IWR3'!$N$2:$N$1000),0)=8)),--(IFERROR(YEAR('IWR3'!$N$2:$N$1000),0)=2021),--(IFERROR('IWR3'!$J$2:$J$1000,0)="Word"))

 

[virtuosok]

Thanks! This works!
I must have missed one extra bracket!

 

[maabadi]

You're Welcome & Thanks for Follow-up.