Formula to Count items within a cell

Beronica Muller

Hello,

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.