How can one sum qualitative multiple choice questions?

275
1
06-23-2022 08:44 AM
rescobar
New Contributor III

In my Survey 123 sheet I have three qualitative multiple choice questions with the labels being "Very Bad, Bad... etc." I have assigned a number ranking for each choice from 1-5. How would one sum the combined numerical rating in a another field? I can't seem to get a formula that will do this. 

Thank you!

0 Kudos
1 Reply
abureaux
MVP Regular Contributor

Simply adding them up should work:

abureaux_2-1656004646596.png

 

abureaux_1-1656004615731.png

Result:

abureaux_3-1656004685718.png

 

0 Kudos