Hello Forum,
I am seeking assistance on how to count unique job roles on different rows when 1 of 3 columns has the word "Yes".
On the attached worksheet, I have roles like Developer, QA, Scrum, etc. On a project, 1 or more resources may be assigned to perform that role. The same resource name can be on multiple rows, but I only want to count the resource name 1 time "if" they have a "Yes" in any 1 of the 3 columns listed (D, J, P). I do not know how to do this and am hoping someone can help. Please see attached spreadsheet.
Thank you very much for your assistance in advance.
Bookmarks