Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF Not <>
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! |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
JE McGimpsey wrote...
Simplest is probably: =SUM(B1:B5)-SUMIF(A1:A5,"Green",B1:B5) .... !? Why not =SUMIF(A1:A5,"<Green",B1:B5) ? |
#4
|
|||
|
|||
Because I was answering a different question than was asked??? Or
perhaps my head was elsewhere. Dunno... Thanks for the correction. In article . com, "Harlan Grove" wrote: !? Why not =SUMIF(A1:A5,"<Green",B1:B5) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |