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!
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!