| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Words
I am wanting to create a formula to count how many times the word Complete shows up in a column. How do I do this? Thanks! -- tkinsella ------------------------------------------------------------------------ tkinsella's Profile: http://www.excelforum.com/member.php...o&userid=32960 View this thread: http://www.excelforum.com/showthread...hreadid=527867 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Words
=countif(A:A,"Complete")
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "tkinsella" wrote in message ... I am wanting to create a formula to count how many times the word Complete shows up in a column. How do I do this? Thanks! -- tkinsella ------------------------------------------------------------------------ tkinsella's Profile: http://www.excelforum.com/member.php...o&userid=32960 View this thread: http://www.excelforum.com/showthread...hreadid=527867 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Words
Assuming you're just looking for cells that contain "complete" and nothing else.... =COUNTIF(A:A,"complete") -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=527867 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Words
Thanks! This is perfect! -- tkinsella ------------------------------------------------------------------------ tkinsella's Profile: http://www.excelforum.com/member.php...o&userid=32960 View this thread: http://www.excelforum.com/showthread...hreadid=527867 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting words with numbers in them | Excel Discussion (Misc queries) | |||
| Using COUNTIF for Counting Words? | Excel Worksheet Functions | |||
| Counting words | Excel Discussion (Misc queries) | |||
| counting specific words | Excel Worksheet Functions | |||
| counting instances of words in a worksheet cell | Excel Discussion (Misc queries) | |||
Linear Mode
