Formula to Count items within a cell



I have a voting poll where I have listed 15 items and each user will select their top three choices. Now that I am beginning to receive their responses, I need to create a formula that will provide the total number of selections for each of the 15 items. For example, if I have the the colors red, blue and green as a choice option, I would like to know how many people selected each one of those choices.

Is anyone able to help me with that?

Thanks in advance.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!