In B2:C5 list Open / 4, Closed / 5, Open / 3 and Open / 5. Enter the minimum priority in E1. Both conditions must be true on one row.

Use the threshold cell in the criterion

=COUNTIFS(B2:B5,"Open",C2:C5,">="&E1)

With E1 at 4 the result is 2. The ampersand joins the operator and the threshold value.

Open priority 4 and Open priority 5 qualify. Closed priority 5 and Open priority 3 do not.

Illustrated AND condition on a four-row queue.

Raise the threshold by one

Set E1 to 5 and expect 1. Close the remaining open priority-5 request in a copy and expect 0. If a result surprises you, check the labels, numeric priority values and whether the criteria ranges start and end on the same rows.

Raising the threshold to 5 leaves one matching request.

Illustrated boundary check.

Related Microsoft Excel reference