Formula to count of items in a multi dropdown list

lcamacho19911 ✭✭✭
edited 12/09/19 in Formulas and Functions


The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion). 

I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple values.  I hope I explain well my point.

Luis from PR

colum with dropdown multiselect.JPG

Capture results.JPG

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!