Summing a Multi-Select

I'm trying to figure out an easy/dynamic way to sum a column. Right now, I have Column A in Sheet 1 that is a multi-select. I want to lookup the result of that multi-select in Sheet 2, and total the values from Column B.

So I know how to do it manually (i.e. - by spelling out all the values using FIND () or HAS ()) as part of a SUMIFS(), but is there not a more dynamic way to sum up multiple values? The problem is, I have over 400 selections, so writing the formula (while possible) would be tedious.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!