I will assume Columns as follows:

A - list of names you want to search and count how many times a name
appears.

B - list of names you want to look up in col. A.

C - empty column where we can place the count formula

assume you want to look up the name found in B3, then in C3 place the
formula:

=COUNTIF(A:A,B3)


"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.