SUMIFS one of two names found

fred sodergren

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")

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

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