Hi,

I have a SUMIFS formula that sums the figures in the Values column for all items with a value of Blue in the Color column.

=SUMIFS(Value, Color, “Blue”)

Is it possible that to have a SUMIFS formula that can exclude a value? For example, sum every value in the Color column except those that are Green?

Or, do I need to list all the values that I do want (eg, Red, White, Black, etc)?

What is the syntax for making this work, if it is possible?

Thanks very much

Dave