Countifs: Using a reference for the criterion

I have a summary sheet that includes the following columns.

• Ticket#
• Last Name
• First Name
• Biosketch

In the Biosketch column (and two others), I'm using the formula: =COUNTIFS({GH Ticket #}, 1114, {Last Name}, "Meyer", {Bio}, 1)

I would prefer to use a reference to the column in the summary sheet instead of typing "1114" and "Meyer".

Each row has a different ticket and name value, so it's cumbersome to update the formula three times for each row.

Any suggestions?

Thanks in advance...