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?
Answers
-
@Matt C. I would create a summary field, name it MAX Values, and put that number in there. The field would be [MAX Values]#
-
Thank you @Eric Law . I think I will create a reference table, since the value is used across multiple sheets. I thought there may be a canned function, but guess not. Thank You
Help Article Resources
Categories
Check out the Formula Handbook template!