Conditional SUMIF with Symbols

Amy Evans

Hello,

In this screenshot, I'd like to Sum the values in Column8 only if the dots in Column9 are: Yellow, Green, or Blue.

I believe I need to insert an "OR" or add a comma between the colors?

Thanks!

AE

Paul Newcome

You could use the OR statement or you could specify "not red".

=SUMIFS([Column8]:[Column8], [Column9]:[Column9], OR(@cell = "Yellow", @cell = "Green", @cell = "Blue"))

or

=SUMIFS([Column8]:[Column8], [Column9]:[Column9], @cell <> "Red")

Amy Evans

Thanks, Paul, for the options! Excellent and quick, as always.

Paul Newcome

You could use the OR statement or you could specify "not red".

=SUMIFS([Column8]:[Column8], [Column9]:[Column9], OR(@cell = "Yellow", @cell = "Green", @cell = "Blue"))

or

=SUMIFS([Column8]:[Column8], [Column9]:[Column9], @cell <> "Red")

Amy Evans

Thanks, Paul, for the options! Excellent and quick, as always.

Paul Newcome

Happy to help! 👍️