Forum Discussion

S31573's avatar
S31573
Copper Contributor
Feb 08, 2021

Formula for Distinct Count with Multiple Criteria

I found a formula that helps me do a distinct count =SUMPRODUCT((Data!$A:$A<>"")/COUNTIF(Data!$A:$A,Data!$A:$A&"")) However, now I need this to contain 2 criteria.  I have similar formula but this ...

Resources