HI I have the following formula which is counting all the dates in column B that match the month number in cell I2
=SUMPRODUCT(--(MONTH('Tracker'!$B$3:$B$5000)=$I$1),--('Tracker'!$B$3:$B$5000<>""))
However I need to add another criteria to the formula so that it looks for a specific text in another column as well. I have tried the following but neither works and I don't know enough about SUMPRODUCT to fix it, any ideas?
=SUMPRODUCT(--(MONTH('Tracker'!$B$3:$B$5000)=$I$1),--('Tracker'!$B$3:$B$5000<>""),--(Tracker'!$D$2:$D$5000="no answer"))
=SUMPRODUCT(--(MONTH('Tracker'!$B$3:$B$5000)=$I$1),--('Tracker'!$B$3:$B$5000<>"")*(Tracker'!$D$2:$D$5000="no answer"))
Thanks
J
Bookmarks