countifs with multiple criteria NOT equal to

I'm trying to create a formula to count a dataset if not equal to multiple criteria: 

=COUNTIFS({TTKENG 2021 RoadMap Priority}, "Red", {TTKENG 2021 RoadMap Range 3}, <>"9 Released", {TTKENG 2021 RoadMap Range 3}, <>"X On Hold", {TTKENG 2021 RoadMap Range 3}, <>"Z Rejected")

I want to count all EXCEPT those items "9 Released", "X On Hold" and "Z Rejected". This is giving me a number, but it isn't calculating correctly. Any suggestions?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!