| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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 > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
have a look in the help index for COUNTIF
-- Don Guillett SalesAid Software (E-Mail Removed) "mower racer" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > 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 > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
="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 > > > -- > 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 > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Countif - problem counting text, other text | gmoore3055 | Microsoft Excel Worksheet Functions | 1 | 4th Feb 2010 10:30 PM |
| Counting occurences of text string in a text file | Mike Archer | Microsoft Excel Programming | 1 | 10th Jul 2008 09:34 PM |
| Counting a mixed text/number column based on text in another colum | =?Utf-8?B?U2llcnJhIFZpc3RhIFN0ZXZl?= | Microsoft Excel Misc | 3 | 17th Dec 2006 05:30 PM |
| Counting number of text rows in a text box? | Piri | Microsoft Access Form Coding | 1 | 8th Mar 2006 01:59 PM |
| Counting Occurrence of Text within Text in Cells in Range. | =?Utf-8?B?SmVyZW15IE4u?= | Microsoft Excel Worksheet Functions | 1 | 8th Sep 2005 05:16 AM |
