Summing a MultiSelect
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 multiselect. I want to lookup the result of that multiselect 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.
Answers

The SQL Server SUM() function is an aggregate function that calculates the sum of all or distinct values in an expression. The syntax of the SUM() function is as follows: SUM([ALL  DISTINCT ] expression) In this syntax: ALL instructs the SUM() function to return the sum of all values including duplicates.

Are you able to provide a screenshot for reference?

@tanukrishna So can I use SQL functions like that w/out making any other database connections? I understand SQL, but just wanted to be sure there wasn't some ODBC or other connection needed.
@Paul Newcome let me see if I can figure out how to best represent it in a screen grab.
Help Article Resources
Categories
Check out the Formula Handbook template!