Count if Critieria with Eliminating duplicates

Stephanie Foster

Hi, I am trying to count how many of my tax id numbers without duplicates from (Column name TIN) that are associated with a certain contract type "AFF" contract (Column AFFDNGEMP). I have tried the Count if formula but it does not give me the number of TINs without duplicates. How can I combine the two formulas so that I can role this up to a visual for my dashboard? HELP!

Paul Newcome

Try...

=COUNT(DISTINCT(COLLECT(TIN:TIN, AFFDNGEMP:AFFDNGEMP, "AFF")))

Paul Newcome

Try...

=COUNT(DISTINCT(COLLECT(TIN:TIN, AFFDNGEMP:AFFDNGEMP, "AFF")))

Stephanie Foster

It worked! Thanks!!!

Paul Newcome

Happy to help. 👍️