You rock!!!, that is exactly what I was looking for!!!
Thanks!!!!!
VBA Noob Wrote:
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
--
philcassell
------------------------------------------------------------------------
philcassell's Profile:
http://www.excelforum.com/member.php...o&userid=36520
View this thread:
http://www.excelforum.com/showthread...hreadid=562737