Unique filter

AGM

Can someone help me with the below formula?

I am trying to count unique values within a column that also have a specific condition.

=COUNTIFS, DISTINCT({CBA - Master Range 4}, {CBA - Master Range 2}, "Accepted", {CBA - Master Range 1}, =Title@row)

Paul Newcome

Try this:

=COUNT(DISTINCT(COLLECT({CBA - Master Range 4}, {CBA - Master Range 2}, @cell = "Accepted", {CBA - Master Range 1}, @cell = Title@row)))