Count If Site matches Question

tchav

Hello,

I am trying to pull a count of a column "Food Safety Hold" if the "site" matches.

I am trying this but it is not working.

=COUNTIF(MATCH({Site}, Site@row, {Food Safety Hold}, 0))

=COUNTIF({Food Safety Hold}, Site@row, {Site})

Paul Newcome

What kind of column is "Food Safety Hold"?

tchav

It is a dropdown list. I only need the count and not the value

Paul Newcome

So you are trying to count rows where that column is not blank and the site column is a match?

If so:

=COUNTIFS({Site}, @cell = Site@row, {Dropdown}, @cell <> "")

tchav

Yes i only need the count. When i enter that formula in it says INVALIDREF

Paul Newcome

You will need to create the {cross sheet references} as needed.