SUMIF Not <>

D

Doug Laidlaw

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?
Thank you!
 
J

JE McGimpsey

Because I was answering a different question than was asked??? Or
perhaps my head was elsewhere. Dunno...

Thanks for the correction.
 
Top