Sumif (or something similar) using a Multi-Select as a criteria
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.
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).
Help Article Resources
Check out the Formula Handbook template!