https://community.esri.com/t5/arcgis-survey123-questions/how-can-one-sum-qualitative-multiple-choice/m-p/1185619#M43402 <P>Simply adding them up should work:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_2-1656004646596.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/44193iAAA235507252C23B/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_2-1656004646596.png" alt="abureaux_2-1656004646596.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_1-1656004615731.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/44192i9A25782D2521B193/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_1-1656004615731.png" alt="abureaux_1-1656004615731.png" /></span></P><P><STRONG>Result:</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_3-1656004685718.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/44194iD9D875D698CC560F/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_3-1656004685718.png" alt="abureaux_3-1656004685718.png" /></span></P><P>&nbsp;</P> Thu, 23 Jun 2022 17:18:20 GMT abureaux 2022-06-23T17:18:20Z https://community.esri.com/t5/arcgis-survey123-questions/how-can-one-sum-qualitative-multiple-choice/m-p/1185565#M43396 <P>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.&nbsp;</P><P>Thank you!</P> Thu, 23 Jun 2022 15:44:55 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-can-one-sum-qualitative-multiple-choice/m-p/1185565#M43396 rescobar 2022-06-23T15:44:55Z https://community.esri.com/t5/arcgis-survey123-questions/how-can-one-sum-qualitative-multiple-choice/m-p/1185619#M43402 <P>Simply adding them up should work:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_2-1656004646596.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/44193iAAA235507252C23B/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_2-1656004646596.png" alt="abureaux_2-1656004646596.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_1-1656004615731.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/44192i9A25782D2521B193/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_1-1656004615731.png" alt="abureaux_1-1656004615731.png" /></span></P><P><STRONG>Result:</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_3-1656004685718.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/44194iD9D875D698CC560F/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_3-1656004685718.png" alt="abureaux_3-1656004685718.png" /></span></P><P>&nbsp;</P> Thu, 23 Jun 2022 17:18:20 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-can-one-sum-qualitative-multiple-choice/m-p/1185619#M43402 abureaux 2022-06-23T17:18:20Z