Excel 2007 : Sumif(s) formula help

[A[L]C]

Hi all,

I have the data

Please Login or Register  to view this content.

I would like to sum the far right values, if the 3rd column does NOT contain the word metal AND "In" in the 2nd column.

For example the sumif(s) would not include the 1st or 2nd lines as they contain metals and are In. It would however include the last line as this contains metals, but is an Out.

Hope that makes sense.

Thanks
Paul

[NBVC]

=Sumifs(E1:E10,B1:B10,"In",C1:C10,"<>*metal*")

where table above is in A1:E10.

[A[L]C]

Thanks NBVC. Not quite what I am after, if I read this correctly it will also exclude any that are "Out". However I would like it to only exclude those which are "In" AND "Metals".

[NBVC]

Then perhaps:

=SUMIFS(E1:E10,B1:B10,"In",C1:C10,"<>*metal*")+SUMIF(B1:B10,"<>IN",E1:E10)

[A[L]C]

Lovely! I see what you have done there, a bit of lateral thinking. Thank you

Changed to solved and added rep