|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 21st, 2005, 02:58 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting words............
How can I give the total of how many times a word appears in a column? -- Smokey_Vol ------------------------------------------------------------------------ Smokey_Vol's Profile: http://www.excelforum.com/member.php...o&userid=29717 View this thread: http://www.excelforum.com/showthread...hreadid=495182 
|
|
#3
December 21st, 2005, 03:35 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Counting words............
Smokey_Vol Wrote: How can I give the total of how many times a word appears in a column? Assuming your column range is A1:A100, you can use this =COUNTIF(A1:A100,\"WORD_THAT_NEEDS_TO_BE_COUNTED\" )[/b] OR IF THE WORD THAT YOU WANT TO COUNT IS, SAY, IN CELL B1, THE ABOVE FORMULA CAN BE MODIFIED TO BE [b]=COUNTIF(A1:A100,\"*\"&B1&\"*\") Hope this is what you looking for. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=495182
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Determine how many times all words are used in a doc | [email protected] | General Discussion | 8 | December 17th, 2005 01:04 PM |
| In Word, word usage | Cheri | General Discussion | 2 | December 6th, 2005 09:44 PM |
| Using COUNTIF for Counting Words? | Rich B | Worksheet Functions | 2 | September 26th, 2005 08:40 PM |
| counting specific words | jen | Worksheet Functions | 2 | June 25th, 2005 12:46 AM |
| words as data for formula or chart | Andy_CYXU | Charts and Charting | 2 | January 4th, 2004 04:22 AM |
Linear Mode
