How to count the # of multi selected items from a drop down selection?

I have a column that has 5 selections from a drop down, and allows for multi-selection. Is there a way to count the number of times 1 selection was made, 2 selections were made, 3 selections were made etc.?

I tried using CountM, but I was not able to get the formula to produce the expected results, if any. Any idea on how to do this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!