Calculating percent of dropdown values selected in a cell
I have a multiple select drop down column that has 10 possible values. It's being used as a checklist. I want to calculat the % of values selected in that cell. So for instance. If I checked off 6 things in the drop down out of a possible 10, the formula would return 60%. I know to use COUNTM to count the number of selected values, but how do I count the number of possible Values (10 in this case) that will change as I add or subtract values?
Help Article Resources
Check out the Formula Handbook template!