SUMIF for terms in multiple selection drop down

kathryn.marini

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!

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.