SUMIFS & CONTAINS formula help



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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!