Forum Discussion
Solved
Count Unique Values with Multiple Countif Conditions
Hello All, I could use some help figuring out how to create a formula that will calculate the number of unique values where there are multiple countif conditions. This is a sample of the kind...
=COUNT(UNIQUE(FILTER($C$2:$C$22,($D$2:$D$22=G12)*(($E$2:$E$22=H12)+($E$2:$E$22=I12)))))
With Office 365 you can apply UNIQUE and FILTER.
=COUNT(UNIQUE(FILTER($C$2:$C$22,($D$2:$D$22=G12)*(($E$2:$E$22=H12)+($E$2:$E$22=I12)))))
With Office 365 you can apply UNIQUE and FILTER.