Count word if date in other column is a specific month (July)

Hi there,

Sorry if something similar has been posted. I would be grateful of any help with this one.

I'm counting words in one column to give me a tally. This is working with the formula =COUNTIF(Sheet1!A:A, "word"). I would like to then only count these words if the date in another column is a month such as July.

Hope that make sense. Any advice is appreciated!

Try countifS

=COUNTIFS(Sheet1!A:A, "word",Sheet1!B:B,">="&DATE(2015,7,1),Sheet1!B:B,"<="&DATE(2015,7,31))

Thank you! This seems to be working ok.

You're welcome.