SUMIFS & CONTAINS formula help

Hello!

I am trying to total the # of points in a column if multiple criteria is met. One of the columns I need to check is a multiple select column. I've tried the following and it keeps coming back with 0 when the sum should be 2.

=SUMIFS({Master Absorption Form Range 3}, {Master Absorption Form Range 6}, CONTAINS(Group@row, {Master Absorption Form Range 6}))

Note the above is just the first search criteria for the SUMIFS formula.. the other parts of the formula work.. I just can't get it to look for the word "Gold" in the multi select column.

Thank you!

Find more posts tagged with

Accepted answers

All comments

Heather Duff

Hi @Christa Brown ,

Try substituting HAS for CONTAINS. HAS is designed to look within multi-select dropdown columns. That should theoretically fix your problem.

Let me know if it works!

Best,

Heather

Christa Brown

Thanks for the quick reply @Heather Duff. I tried HAS earlier as well with the formula below and it pulls back "0" when it should pull back "2."

=SUMIFS({Master Absorption Form Range 3}, {Master Absorption Form Range 6}, HAS({Master Absorption Form Range 6}, Group@row))

Heather Duff

@Christa Brown Can you provide screenshots of the multi-select column? (black out any sensitive data)

Heather Duff

OH! Try this...

=SUMIFS({Master Absorption Form Range 3}, {Master Absorption Form Range 6}, HAS(@cell, Group@row))

Christa Brown

@Heather Duff - yep! See below. It's a multi select drop down with 5 options to select from. The column is titled "Impacted SAF Groups"

Christa Brown

That did it!! Thank you!!

Heather Duff

Hooray! Glad it worked. Have a great weekend.

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.