COUNTIFS with 3 criterias

Options

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!