Need to Count Unique Values Based on Criteria from a DropDown Collumn


I need a function that can identity duplicates and determine if they should be counted as one or more than one depending on criteria within another column of the spreadsheet that is a dropdown.

The specific context is there is a Name Column (Column A) and a Dropdown Column (Column B), Column B has three options "Yes - the Same", "Yes - Different", and "No".

"Yes - the Same" should be counted as one

"Yes - Different" should count all the duplicates in the name column

"No" - should count all the duplicates in the name column

I have tried putting multiple functions together using the Distinct, IF, COUNTIFS, AND commands but have had no luck so far.

This function will live in the sheet summary tab and will referenced by other simpler functions to track things.

Please let me know if there are any questions and I would really appreciate it if somebody could help me out here.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!