Summarize values selected from an enum list (essentially countif selected / totalcount)

[kmelendez128]

I'm new to appsheets and am trying to figure out how I can count values selected off a enumlist. 

I am using the forms view; the form will be used to capture and collect assessment data. 

I have five different questions that are enumlists. Each question has between 3-5 answers/values that can be selected. I want to be able to count all of the values/answers that are selected out of the total values available. Ideally, I would like to be able to pull out the percentage of all values selected out of all available values (for example, a total of 20 out of 31 values available were selected accross the five questions, which accounts for a 64% performance based on the assessment). Taking it a step further, I would like to be able to pull a list of the values that weren't selected and what associated question they were a part of. 

Any help is appreciated. Thank you!

[AleksiAlkio · Accepted solution]

Because the EnumList generates a list, you can use for example SUM([EnumList]) or COUNT([EnumList]). Then you can combine them like COUNT([EnumList1])+COUNT([EnumList])+..etc. 

The percentage can be like.. 1.0*(COUNT([EnumList1])+COUNT([EnumList2])+..)/31

The last request.. LIST("Option1","Option2",..,"Optione31")-[EnumList1]-[EnumList2]-..etc. should give you the list of not used options.

[kmelendez128]

This worked great, thank you! A follow up question (if you're able to answer): 

- is there a expression to count the total options (i.e. 31) in the different enumlists so that the total number is auto-calculated in the event that more options are added? or is the best way to update that in the expression every time a new item is added?

[AleksiAlkio]

You can't read the quantity from something that has not recorded. One option is to read your options from a table and then you can read the quantity from that table dynamically.