COUNTIFS WITH DISTINCT
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?
Help Article Resources
Check out the Formula Handbook template!