Hello Community, I am attempting to count unique numbers in one column if the code in the other column is "X". =COUNTIF(DISTINCT([Claim Number]:[Claim Number], [Contract Type]:[Contract Type], @cell = "LW"))
Claim numbers are formatted as letter and numbers. Each part work fine separately, but not together.
What am I doing wrong
Help Article Resources
Check out the Formula Handbook template!