Extract data on drop-down list


I have a drop-down list with names, and am trying to get a count of items (rows) against each name in the drop-down list. That would be as simple as =countifs, HOWEVER, I'm stuck in that that there can be more than one name in the cell of a specific row, and in this case the formula doesn't recognize any individual name in that "group" of names in that specific row. Any advice on how to solve that? Thanks!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!