the NOT function

Options

I am having trouble with the below formula, I want to exclude the "Unplanned"

=SUMIFS({Education 2021 Range 3}, {Education 2021 Range 1}, NOT(CONTAINS("Unplanned", @cell)), {Education 2021 Range 4}, "(Stage 3) 3.1 - RFP Submitted", {Education 2021 Range 2}, MONTH(@cell) = 1))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!