Countifs: Using a reference for the criterion

meyerd61361

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

Andrée Starå

Hi,

You can use the @row function instead. 

Try something like.

=COUNTIFS({GH Ticket #}, [GH Ticket #]@row, {Last Name}, [Last Name]@row, {Bio}, 1)

Did it work

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

meyerd61361

Andrée, that was it!  Thanks so much!!

 

Diane