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

have a look at
=COUNTIF(

--
Don Guillett
SalesAid Software

"Smokey_Vol" wrote
in message ...

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

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