use countif():

=COUNTIF($A:$A,C1) where C1 contains pass.
--
Gary's Student


"mower racer" wrote:


Hi Guys

If i have a column in excel with text in it. Either "pass" or "fail",
how can i count the number of entries? Is there a formula to do this?

cheers


--
mower racer
------------------------------------------------------------------------
mower racer's Profile: http://www.excelforum.com/member.php...o&userid=35034
View this thread: http://www.excelforum.com/showthread...hreadid=547799