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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!