SUMIF Not <>

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Simplest is probably:

=SUM(B1:B5)-SUMIF(A1:A5,"Green",B1:B5)
 
Because I was answering a different question than was asked??? Or
perhaps my head was elsewhere. Dunno...

Thanks for the correction.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF data that falls within a range 3
SUMIF - Sum_Range is misleading 3
SUMIF with criteria "<>" & "=" 4
Sumif criteria "equal" 3
sumifs/sumproduct 8
Sumif across a table 1
Create List 7
SumProduct or sumif 4

Back
Top