Need to sum numbers in a dropdown multi select cell
I have a multiselect cell that is used to select the time certain training education takes. I have .5 for 30 mins and 1 for an hour. Our educators can also select the 1 and .5 if the education takes an hour and a half. I would like to be able to sum these two if they selected both. I have searched this community and have found the countm and contains but can't seem to figure how to make them sum. Appreciate any insights. Thanks
Help Article Resources
Check out the Formula Handbook template!