Extract data on drop-down list

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!