Countif Formula with Criteria

SmeyerEnpointe

I am counting "On-Time" in another sheet and want to add additional criteria. So countif column Proof Delivery Status is "On-time" and column Alterations is NOT checked.

Current formula

=COUNTIFS({Premedia Completed Proof Delivery Status}, "On-time")

Shouldn't this formula work

=COUNTIFS({Premedia Completed Proof Delivery Status}, "On-time", {Premedia Completed Alteration}, 0)

Paul Newcome

Yes. That should be working. Are you getting the wrong number or an error?

SmeyerEnpointe

Wrong number, but I believe I figured it out. I had to reconfigure the status column. Thank you for verifying it was correct.

Paul Newcome

Happy to help. 👍️