Count distinct values based on other cell criteria

Options

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!