SUMIFS one of two names found

If Team One OR Team Two are found in the 'Team' column, add up the values found in 'Story Points' column.

This formula gives me an error:

=IFERROR(SUMIFS([Story Points]:[Story Points], OR(Team:Team = "Team One", Team:Team = "Team Two"), [RezW#]:[RezW#], [Week#]@row), "nope")

The formula below works fine for a single team name, so is the OR function wrong?

=IFERROR(SUMIFS([Story Points]:[Story Points], Team:Team, "Team One", [RezW#]:[RezW#], [Week#]@row), "nope")

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hi @fred sodergren ,

Try:

=IFERROR(SUMIFS([Story Points]:[Story Points], Team:Team, OR(@cell = "Team One",@cell= "Team Two"), [RezW#]:[RezW#], [Week#]@row), "nope")

Mark

All comments

Mark Cronk

Hi @fred sodergren ,

Try:

=IFERROR(SUMIFS([Story Points]:[Story Points], Team:Team, OR(@cell = "Team One",@cell= "Team Two"), [RezW#]:[RezW#], [Week#]@row), "nope")

Mark

fred sodergren

Awesome, thanks for the help with the syntax!

Mark Cronk

Happy to help. Thanks for contributing to the Community.

Mark

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.