How to use a formula for SUMIFS with more than 2 not contains criteria?

edited 12/22/22 in Formulas and Functions

If I have 3 columns one is "department", the second is "description", and the third is "amount".

I would like to sum up the total "amount" for only department-1 in the "department" column, that doesn't contains "ABC" or "EFG" or "JKL" in the description column.

I am trying to use =SUMIFS({amount}, {department},{department-1},OR(NOT(CONTAINS("ABC", @cell),("EFG",@cell),("JKL",@cell)))}

My concern is with the NOT CONTAINS formula only. please help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!