countifs not including 2 status

I am trying to count if Lilly is the controller, and the status is not cleared or delivered. Having trouble with the formula.  

=COUNTIFS(CONTROLLER:CONTROLLER, "Lilly Spanbauer", {status}, <>"Cleared", {status}, <>"delivered")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!