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?
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!