SUMIFS & CONTAINS formula help

Christa Brown

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!

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.