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:
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.
Bookmarks