Hello, I'm able to count # of stores assigned to a string of managers, but also want to count # unique stores with a certain billing criteria (therefore not having duplicates).
For example, FRANCISCO CASTILLERO reports to MARC SCHWIESOW who reports to PAULO DIAZ. He has 11 stores total.
=COUNTIFS('SHC EL 1-1 thru 7-24-14'!$D:$D,Summary!$A63,'SHC EL 1-1 thru 7-24-14'!$E:$E,Summary!$B63,'SHC EL 1-1 thru 7-24-14'!$G:$G,Summary!$C63) = 15, but I want to not include duplicate stores, so I'm looking for 8 unique stores out of 10.
Can someone assist?
Bookmarks