Countif Formula with Criteria

Options

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)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!