=SUMPRODUCT(--(A1:A10<""),--(ISNUMBER(MATCH(A1:A10,B1:B10,0))))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Michael" wrote in message
...
Hi, I have a list of names in column 1 and another list of names in column
2.
I would like to count how many of the names in column 2 are in column 1. I
have a feeling it will be countif but because the criteria is a range I
can't
get it to work.
Any help would be appreciated.
Thanks.