Countif not containing specific text

Heather K
Heather K
edited 12/09/19 in Formulas and Functions

I am trying to create a formula to count "Red" based on one column but not include certain ones which contain the text "Spring" in another column but I can't get it to work.

Originally I tried this formula:

=COUNTIFS([Aging]:[Aging], "Red", Project:Project, <> "Spring")

However, I realized that won't work because the Project column has variations of "Spring". For example Spring - Other, Spring - Supply, etc.  So how do I create the formula to not count all the ones that contain the word Spring?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!