Simplest is probably:

=SUM(B1:B5)-SUMIF(A1:A5,"Green",B1:B5)


In article ,
Doug Laidlaw wrote:

I'm trying to sum a column of numbers if they do not equal a particular
value. For example in column A1:A5 I have Blue, Red, Green, Yellow, & Purple.
In B1:B5 I have random values, perhaps 10, 20, 30, 40, & 50.

I want to my SUMIf function to add everything except the Green value which
in this case is 30 per my example. What is the simplest way to acheive this?