| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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  -- 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 -- 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 -- 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique text entries in a filtered list... | Excel Worksheet Functions | |||
| counting total cells with text | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
| Counting NUMBERS &/or TEXT from a column to other sheet ? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
