How can I give the total of how many times a word appears in a column?
How can I give the total of how many times a word appears in a column?
Thanks
JeremyA
have a look at
=COUNTIF(
--
Don Guillett
SalesAid Software
[email protected]
"Smokey_Vol" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
Assuming your column range is A1:A100, you can use thisOriginally Posted by Smokey_Vol
=countif(A1:A100,"word_that_needs_to_be_counted") OR
if the word that you want to count is, say, in Cell B1, the above formula can be modified to be
=countif(A1:A100,"*"&B1&"*")
Hope this is what you looking for.
Regards.
BenjieLop
Houston, TX
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks