Counting text?
 

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 :confused:


--
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

Counting text?
 

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 :confused:


--
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

Counting text?
 

have a look in the help index for COUNTIF

--
Don Guillett
SalesAid Software

"mower racer"
wrote in message
...

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 :confused:


--
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

Counting text?
 

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

Format as "Word Wrap"

Vaya con Dios,
Chuck, CABGx3




"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 :confused:


--
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

Counting text?
 

Sorted! Thanks guys!


--
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