Count if column 1 contains Y AND column 2 contains specific word

[Wayne Herbert]

Hello again. :D

Similar to my last request, I would like a formula that again counts how many "Y's" appear in one column, but only when the matching rows in another column also contain the words "staff" or "tutor".

Here is the formula I have tried, which I modified from the previously supplied formula, but it only returns a 0:

Please Login or Register  to view this content.

In the attached example, there are 4 people who match the criteria (2 members of staff and 2 tutors), but I only need to count those out of the 4 who have a Y in the other column.

Can someone please help with that formula? Thanks.

[Sam Capricci]

how about this... =COUNTIFS(B:B,"y",A:A,"*staff*")+COUNTIFS(B:B,"y",A:A,"*tutor*")

[Wayne Herbert]

Worked like a charm. Thank you so much.

[Sam Capricci]

You're welcome and thanks for the rep!