Cross sheet reference help please!

Chrissy H

Sheet 1 is called "2024 Sponsorship Campaigns" and column 3 is called "Job Req ID"

Sheet 2 is called "2024 Application Source AB" column 5 is called "Job Req ID" and column 6 is called "Source Details"

If the "Job Req ID' in sheet 1 matches the "Job Req ID" in sheet 2 I need to count the number of rows in sheet 2 that contain "Western" under the column "Source Details"

I hope this makes sense, and would appreciate any help

Paul Newcome

You would use a COUNTIFS.

=COUNTIFS({Sheet 2 Job Req ID}, @cell = [Job Req ID]@row, {Sheet 2 Source Details}, @cell = "Western")