# count number of times a word appears

1. ## count number of times a word appears

I need to count how many times the work WO appears and return the result in column P3

it could be in a1, b1, b2, b3

2. ## Re: count number of times a word appears

Hi

welcome to the forum..
In p3.. write formula as

Formula:
`Please Login or Register  to view this content.`

3. ## Re: count number of times a word appears

If maybe have some wo in some other cells use

Formula:
`Please Login or Register  to view this content.`

OR else

Formula:
`Please Login or Register  to view this content.`

4. ## Re: count number of times a word appears

Moderator Request:

Not marking your thread as SOLVED, is not an Option. Is violation of rule#9 of our Forum Rules.

As i see from your previous threads you wont feedback for thanking anybody that helped you to find your solution and you not even mark your thread as solved even in -at least 1 case-a Moderator asked for you to do this.

http://www.excelforum.com/excel-gene...-hh-mm-ss.html

http://www.excelforum.com/excel-form...s-by-mins.html **

http://www.excelforum.com/excel-gene...xt-column.html

http://www.excelforum.com/excel-gene...onth-year.html

http://www.excelforum.com/excel-form...05#post3275105

So i have to request for you to do this(mark your threads as SOLVED) Immediately!

5. ## Re: count number of times a word appears

how do i solve em mate

7. ## Re: count number of times a word appears

how can i do it so that it counts WO & WL

also how do i solve this

8. ## Re: count number of times a word appears

Last warning:

Your question has been solved.This is another question.So, Mark this this(and your other Threads) as SOLVED, as I explained how to do this in post#6, or else i'll close your thread now!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1