Using Distinct Count based on other criteria

Algreen7032

I need to create a formula that will show me the distinct count of an Assignment number, for Team 1 if the date is 3/10/2025. I have a sperate sheet set up referencing this sheet. I'm able to get total count, but not distinct.

Paul Newcome

Try something like this:

=COUNT(DISTINCT(COLLECT({Assignment}, {Team}, @cell = "1", {Date}, @cell = DATE(2025, 03, 10))))

Kelly Moore

Hey @Algreen7032

What is your current formula?

Kelly

Algreen7032

=COUNTIFS({Bill-Pay WW Range 1}, HAS(@cell, [Upload Week]@row), {Bill-Pay WW Range Team}, "1")

Paul Newcome

Try something like this:

=COUNT(DISTINCT(COLLECT({Assignment}, {Team}, @cell = "1", {Date}, @cell = DATE(2025, 03, 10))))

Algreen7032

It worked! Thank you so much - you're a lifesaver!

Paul Newcome

Happy to help. 👍️