COUNTIFS WITH DISTINCT

Options

HI Everyone,

I am trying to calculate the distinct values in column Contain using countifs and distinct however i need the range of contain to be included in the range.

Column7,8 week3 will be my source chart.

COUNT(DISTINCT(COUNTIFS()))) i've tried using this but i can't incorporate the "contain" column, would you recommend a workaround?

thank you

https://app.smartsheet.com/b/publish?EQBCT=9a4850b961184987948525b2b6d09672


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!