Count distinct values based on other cell criteria


I have been able to figure out how to count distinct values in a column. Now I would like an additional complexity of asking the formula only to count cells if it meets the criteria in another column.

If the value in the Status column is 'Live', count the distinct number values in the UniqueDiseaseID column.

=COUNTIF(Status2:Status1083, "Live") COUNT(DISTINCT(UniqueChapterID2:UniqueChapterID1083))

I got this far, I am sure syntax is a mess.

Thanks for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!