Mulitple negative conditions SUMIFS

[Peter-Jan De Smedt]

Hi

I sumifs'ed for these values

Apples Oranges Pears Kiwis Bananas Peaches

and now I would like to sum all others which are none of the above.

I can manage one with eg adding "<>Apples" but i can't manage more than one.

Any suggestions anyone? Any help would be much appreciated!

 

[Colin Legg]

Hi,


Take the sum of all of the values (eg SUM(A:A)) and then subtract the SUMIF(s) values of apples, oranges etc... which you've already calculated.