COUNTIFS with 3 criterias


Hello all,

I'm in need of writing a formula that takes into consideration 3 rows but one of them has values for which I do not care for. So I have Status (Complete, In Progress, Cancelled, Deferred), I have my second criteria which is a Yes/No column and I have my third criteria of values such as Blue, Red, Yellow.

My formula needs to be something like, countifs yellow and blue and when it comes to status I want to emit Cancelled and Deferred. Can anyone provide any ideas how to write?

Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!