SUMIFS to exclude a value

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

Hi,
U can use

=SUMIFS(Value,Color,"<>"&"Green")


Thanks & Regards,
CMA Vishal Srivastava

try:

http://www.stockkevin.com/2014/04/ex...l#.WDJ9INI0OHs