Using COUNTIFS and DISTINCT and Exclude Values in the Same Column


I want to count distinct names and need to remove child rows (within the same column) with different references text from the count. This is a report formula referencing another sheet.

=COUNT(DISTINCT({Team db & Tracker Range 2}))

That formula works great to get an over all unique count of names.

The text I do not wanted counted as part of Range 2 are: "Former" and "Master".

I've tried various forms of COUNTIFS, NOT, and <>. However, I cannot figure out how to count unique names AND exclude these the two text names of Former and Master.

Thanks in advance for any advice.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!