Countif not containing specific text
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
Check out the Formula Handbook template!