Help

Summing Number in Multi Select

Topic Labels: Formulas
1178 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Harry_Batten
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, if I have a cell with a range of numbers in, as selected via a multi select, is there a formula that can add these numbers up and give me the total, for example i'd like a column that will show the total of the numbers in image of the cell attached, which would be 14. 

Thanks

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

There is no easy nor straightforward way of doing that. You would need to switch that field to a linked record field.

SUM(
  IF( FIND("2", {multiselect}, 2),
  IF( FIND("5", {multiselect}, 5),
  IF( FIND("7", {multiselect}, 7)
)

If there are other possible values for the multiselect, you will need to adjust the formula.

If there are two digit numbers as possible values, you will need to adjust the formula (and possibly the select choices) even more.