Summing a Multi-Select

Mike Rini

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.

tanukrishna

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.

Paul Newcome

Are you able to provide a screenshot for reference?

Mike Rini

@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.