Need help with Distinct Count with multiple filters please!

asimcock

Hi All! I'm trying to figure out how to build a formula to track how many clients still have outstanding issues on a different sheet.

I have a basic count of outstanding tasks.

=COUNTIFS({Reference Sheet}, "Outstanding Task")

When I tried to add Distinct to this, it understandably changed my total to 1.

=COUNTIFS({Reference Sheet},DISTINCT({Reference Sheet Tier-Client Number} "Outstanding Task"))

Could someone please take a look? I saw someone used Collect on another formula, but I'm not sure if I'd have collect the different pieces separately?

Thank you!

Ashley

Mark Cronk

Try:

=Distinct(Collect({Reference Sheet Tier-Client Number}, {Reference Sheet}, @cell="Outstanding Task"))

Work?

Mark

asimcock

Thank you for taking a look Mark! It gives me an invalid ref, question for the piece (Reference Sheet}, @cell="Outstanding Task")), do I need to select which column to pull that data from that is part of the prior range as well?