Essentially what I have is the following:
3 columns of data: "Managers", "Employees", and "Type". Each Employee shares a row with one Type and one Manager. Each employee may have multiple Managers and multiple Types (and thus be listed on multiple rows in the column). For clarification, a spreedsheet is attached.
What I need is an equation that counts the number of UNIQUE employees that are typeA, typeB, OR typeC (arbitrary), and who have either manager1 or manager3 (also arbitrary).
Filtering this data on the attached xlsx shows 9 rows of employees, but there are only 6 that are unique.
I would prefer an equation that uses SUMPRODUCT() rather than an array (for convenience), but I would be happy with with anything really.
Let me know if there is any confusion or questions. Much appreciated.
Bookmarks