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.
- MartinLeungMar 02, 2023Copper ContributorThis solution is relevant to me too. TYet, I have modified the illustrated formula by replacing the fixed value by cell reference, (i.e. in the example, by replacing "Tom" with F2 and "North" with G2 and entirely removed the criteria for date range as it's not applicable to my application). It still works.
- S31573Feb 09, 2021Copper Contributor
Thank you but I could not figure out how to apply your formula to my data :0( NikolinoDE