How about this
in B1 enter the name you want to count
enter this function in C1 or wherever this is just an example of how to
count

=COUNTIF(A1:A9,B1)
A1:A9 is the range of names
B1 is the criteria


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=542284