SUMIFS & CONTAINS using multiple columns and criteria.

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

Find more posts tagged with

Accepted answers

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 😉

All comments

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

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.