I take it Col A is a list of names, Col is the name you wish to count
and Col C is your Formula cell.

If so add any of these formula's to C1

=SUMPRODUCT(--($A$1:$A$11=B1))

or

=COUNTIF($A$1:$A$11,B1)

Below is an array (Enter with Ctrl + Alt + Enter) just for info

=SUM(IF($A$1:$A$11=B1,1,0))


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562737