Cross sheet reference - count with multiple parameters

Katie I.

Hello all,

I'm looking for advice to write a cross-sheet reference formula. I have two sheets: one list of all students who have completed internships, and a second sheet with a list of organizations where our students have interned. I'd like to pull in a count of how many students interned at a particular site in a specific academic year.

For example, in the screenshots below: the Cyberdine Systems row should show a 1 in the [# of Interns 2022-23] column and a 0 in the [# of interns 2023-24] column.

I'm having trouble getting started with my formula and appreciate any advice!

Paul Newcome

This should be a standard COUNTIFS.

=COUNTIFS({Site ID}, @cell = [Employer ID]@row, {Academic Year}, @cell = "2022-23")

Paul Newcome

This should be a standard COUNTIFS.

=COUNTIFS({Site ID}, @cell = [Employer ID]@row, {Academic Year}, @cell = "2022-23")

Katie I.

Thank you so much, Paul! I had tried writing the function with COUNTIFS but always have trouble with the syntax. This works perfectly.