SUMIF for terms in multiple selection drop down
Options
Hello. I am trying to assign pricing according to requested testing, where each test has a specific fee associated with it. This fee is redacted in the below screenshot, but is formated as 123.45. I am hoping to get the sum of the different values. What can I correct in my formula to achieve this?
Thanks!
Answers

@kathryn.marini are you the blacked out the price? If so, you may want to do something a little different. My recommendation is to create summaries for the prices, so you can update the prices easier and refer to them in the formula as I believe a sumif needs to refer to cells for it to sum, not just a value.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!