Forum Discussion
S31573
Feb 08, 2021Copper Contributor
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 ...
NikolinoDE
Feb 08, 2021Gold Contributor
Examble with 3 Criterias
Shift + Ctrl + Enter keys together to get the unique result, see screenshot:
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
S31573
Feb 09, 2021Copper Contributor
Thank you but I could not figure out how to apply your formula to my data :0( NikolinoDE