count the value of the drop down selections

in a sheet I 3 separate fields that have values associated with the drop down selection:


Column Headings: Sales Prep Sales Presentation

0 - not prepared 0 - Rep did not show

1 - Basic info 1 - Good presentation

2 - Well prepared 2. Excellent

now I want to count the selection in a total Demo Score field


Sales Rep Name Sales Prep Sales Presentation Demo Score

John Q Public 2- Well prepared 1- Good Presentation 3


How can I sum up the drop down values, 2+1 = 3?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!