I'm running into a little trouble counting distinct values while applying a criteria. For example, there is a list of names with possible duplicate values, name this range "Rng1". Each value in Rng1 is associated with either "Sales", "Marketing", or "Admin." How would you use one formula to count the number of distinct values in Rng1 that correspond to "Sales"?

Thanks in advance!