CountIF for dynamic length column using criteria of Named Range

I have a worksheet with a dynamic length column that contains text data, imported from another application, such as:
"Entrants"
pie
chicken
cow
cow
pie
duck

I have a Named Range containing a list of Exclusions, also in text data.
Named Range would be something like:
"Exclusions"
chicken
cow
duck

I need to count how many times the items within the Exclusions named range occur within the worksheet with the dynamic length column.
(I don't need a breakout for the individual items on the Exclusions named range.)

But when I attempt the following formula it seems to evaluate the first cell only then stop.

Please Login or Register  to view this content.

If I replace "Exclusions" in the formula with one of the entries of the Exclusions named range, then the formula works.

But how would I get it working with a named range?

Using an arrayed formula (CNTRL SHFT ENTER instead of ENTER)

=SUM(COUNTIF(Entrants,Exclusions))
Does that work for you? Returned 4 for me.

Assuming that the Exclusions list is in column A, you can count each item individually in column B:

Please Login or Register  to view this content.

Then you can sum the total of this. I personally don't know a way of using multiple criteria (i did think =COUNTIFS(Entrants!A:A,OR(A1,A2,A3)) would work but it doesn't) so the method above will do the job until you get more accurate solution.