SUMIFS & CONTAINS using multiple columns and criteria.

UserNewQuestions

Hello All!

I am trying to sum cell numbers if conditions (per row) meet the acceptance criteria in two other columns. One of the criteria columns contains multiple contacts. I have tried using MS Copilot AI and even its answers do not work. The formula I am using is: "=SUMIFS([Task Ratio]:[Task Ratio], NeedsText:NeedsText, "Quick Win", CONTAINS("First.Last2", AssignedText:AssignedText))" The attachment contains an excel file for reference. I have also tried using HAS instead of CONTAINS (Formula: "=SUMIFS([Task Ratio]:[Task Ratio], NeedsText:NeedsText, "Quick Win", HAS(@cell, "First.Last2", AssignedText:AssignedText, @row))")

Any help is appreciated especally since the AI was not able to rectify this.

SUMIFS CONTAINS Question R2.xlsx

Regards

CCR

SteyJ

This should fix the issue for you:

=SUMIFS([Task Ratio]:[Task Ratio], NeedsText:NeedsText, 
CONTAINS("Quick Win", @cell), AssignedText:AssignedText,
CONTAINS("First.Last2", @cell))

Based on the criteria inside of the excel sheet, there aren't any rows being summed though -- not sure if this is intentional.

AI can't beat us yet 😉

SteyJ

This should fix the issue for you:

=SUMIFS([Task Ratio]:[Task Ratio], NeedsText:NeedsText, 
CONTAINS("Quick Win", @cell), AssignedText:AssignedText,
CONTAINS("First.Last2", @cell))

Based on the criteria inside of the excel sheet, there aren't any rows being summed though -- not sure if this is intentional.

AI can't beat us yet 😉

UserNewQuestions

Jacob;

Works very well, and it properly adds up the Task Ratio for individual resources.

Thank you!

CCR