countifs not including 2 status

Joey Casullo

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")

Paul Newcome

Are you getting an error or an incorrect count?

Joey Casullo

# invalid ref

Paul Newcome

Ok. What sheet is the data on? Is it on the sheet with the formula or a different sheet?

Joey Casullo

# invalid ref

Same sheet.

Paul Newcome

Ok. In that case you will need to change the cross sheet references {status} to reference the STATUS column in the current sheet Status:Status.

Joey Casullo

OMG, Thank you I copied the formula and did not realize that. ty

Paul Newcome

Happy to help. 👍️