Countif included within a list?

Hey folks is there a function that I can use to count from a list of names only if the names are included within another list. Quick example.

I have a list of twelve names and another list of four names. I would like a count of how many names contained within the long list are also contained within the short list.

Hope this makes sense.

Originally Posted by Ron Coderre

With
A1:A12 containing the long list
and
C1:C4 containing the short list

This formula returns the count of short list items that are on the long list:

Please Login or Register  to view this content.

Is that something you can work with?

Yup, spot on thanks.