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.

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.