Countif across sheets, is what I am trying possible?

Zach Collins

Good afternoon,

I have no idea how to describe this accurately.

Basically,

On the intake sheet, when people fill-out the form, there is a column that will list the site number of the property they are at. That column will show number designations from all three branches.

I want to use this section of a metrics sheet to count how many times a site number of a specific branch has been input into the intake sheet. I set up a third sheet, using three columns, to list each branch's site numbers under the column. The idea would be that this sheet would be a reference for the count to compare against.

And I want to do this for three branches.

Currently I have

=COUNTIF({IntakeSheet Range 1}, HAS(@cell, {SiteListSheet Range 1} ))

but it returns a 0

Any help would be appreciated,

Thank you.

NicoLHC

@Zach Collins this should be no problem, if you like share the sheets or workspace I can add the correct formula. Nico.roepnack@lighthouseconsultings.com