Countifs: Using a reference for the criterion

meyerd61361 ✭✭✭
edited 12/09/19 in Formulas and Functions

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...


Diane M. Meyer

Iowa State University

Ames, IA 50011


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!