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
Check out the Formula Handbook template!