SUMIF with all criteria EXCEPT!

[thewiseguy]

Hi All,

I am currently using this formula:

=SUMIF(BOM!$D$4:$D$100,"MATERIALS",BOM!$J$4:$J$100)

Instead of "MATERIALS", I would like the criteria to be "anything but the word "control""

Is this possible??

 

[dreid1011]

Give this a try:

=SUMIF(BOM!$D$4:$D$100,"<>CONTROL",BOM!$J$4:$J$100)

 

[thewiseguy]

Give this a try:

=SUMIF(BOM!$D$4:$D$100,"<>CONTROL",BOM!$J$4:$J$100)

worked like a charm. thank you.

 

[dreid1011]

worked like a charm. thank you.

You're welcome, and happy to help.