Countifs with Distinct?

Jeff S.
Jeff S.
edited 12/09/19 in Formulas and Functions

I have two columns, Column A and Column B. How can I check Column A for a condition, and then count all the distinct corresponding values in Column B for which that condition is met?

Is there an easy way to do this with Countif / Countifs and Distinct?





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!