Hi,
I have the following working formula:
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"
I have the following working formula:
Excel Formula:
=SUMPRODUCT((--(IFERROR(MONTH('IWR3'!$N$2:$N$1000),0)=8)),--(IFERROR(YEAR('IWR3'!$N$2:$N$1000),0)=2021))
I.e. 'IWR3'!$J$2:$J$1000="Word"