SUMIFS with CONTAINS Formula not working with multi-select column

Stacy M

I cannot get a SUMIFS formula to work with CONTAINS. I am trying to sum the % Allocation column for "Service Delivery" in the types of work column for a member in the owner column (which is a multi-select column). I have tried it six different ways and it's only pulling the cells where there is only one owner listed in the owner column. Where there is more than one person listed, it skips over it.

=SUMIFS([% Allocation]:[% Allocation], [type of work]:[type of work], "Service Delivery", owner:owner, CONTAINS("Brandon", @cell))

The above was for a sheet summary field. I've tried the variation with [owner]:[owner] in another sheet, report, etc. and nothing works. Help, please? I could get the CONTAINS to work with a separate countif function a multi-select column. ?

Thank you for any help! -stacy

Stacy M

Nevermind. I was able to get the result by using FIND("Brandon", @cell) instead of the CONTAIN formula. :)

Andrée Starå

Hi @Stacy M

I hope you're well and safe!

Excellent!

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!