Hi all,
I have the data
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.Please Login or Register to view this content.
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
Bookmarks