Cross sheet reference - count with multiple parameters

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!

Find more posts tagged with

Countif

Accepted answers

Paul Newcome

This should be a standard COUNTIFS.

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.