Sum values assigned to dropdown options

System

This discussion was created from comments split from: Assigning numeric values to drop down menu options.

Audry89

Hello!

This is fantastic! I have a follow-up request. In a case like this, if I have a numeric value assigned to each option of the dropdown menu, when having active the multiple option selection from the dropdown menu, how could I add-up all the values corresponding to all the selected options?

I need to sum-up all the numeric values that correspond to all the options selected. Can someone help he with this?

Thank you very much!

Audry

Leibel S

@Audry89

There are 2 ways you can go about this:

1. write an if statement for each dropdown option and the formula adds it together, something like =IF([Drop Down]@row = "Hello",1,0)+IF([Drop Down]@row = "Bye",2,0)+IF([Drop Down]@row = "Thanks",3,0) - And you can keep adding.
2. You can keep a separate list of each dropdown option in 1 column and the associated value in a second column. Then your formula would be something like: =SUMIFS(Value:Value,Item:Item,HAS([Drop Down]@row,@cell))