Counting text?

[mower racer]

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

 

[Guest]

use countif():

=COUNTIF($A:$A,C1) where C1 contains pass.

 

[Don Guillett]

have a look in the help index for COUNTIF

--
Don Guillett
SalesAid Software
(e-mail address removed)
"mower racer" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

="Pass = "&COUNTIF(A:A,"pass")&CHAR(10)&"Fail = "&COUNTIF(A:A,"fail")

Format as "Word Wrap"

Vaya con Dios,
Chuck, CABGx3

 

[mower racer]

Sorted! Thanks guys!