SUMIF for terms in multiple selection drop down


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?




  • Eric Law
    Eric Law ✭✭✭✭✭✭

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!