Sumif (or something similar) using a Multi-Select as a criteria

Options
MCorbin
MCorbin Overachievers Alumni

I am trying to find a way to allow users to select multiple criteria, where each criteria has a score. And once selected, have a column add up the scores for all criteria selected.


For Example:


Criteria Score

Cat 10

Dog 9

Llama 8

Zebra 7


If the animals are in a multi-select drop down, and the user selects Cat, Llama, and Zebra, I want to be able to create a calculation that find the scores for each and adds them up - coming up with 25. (10+8+7)

I thought about having a supporting sheet that lists the criteria and score, but I can't figure out how to start with a multi-select and find each matching score to add them together.....

I could do this easily with a single select, but I need a multi-select here (and it all has to be in the same column).

Any Suggestions?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!