# How do i get excel to count the number of times a word appears in a range of cells?

1. ## How do i get excel to count the number of times a word appears in a range of cells?

I have a column of cells in which there are some numbers and some words. I need to know how to get Excel to count how many times a certain word appears .

2. ## Re: How do i get excel to count the number of times a word appears in a range of cells?

What happens if the word appears more than once in the same cell?
Do you want an indicator that the word appears in that cell or the total number of occurrences in that cell?

Your description is therefore not clear enough so please provide some sample data with expected results.

3. ## Re: How do i get excel to count the number of times a word appears in a range of cells?

OK, I have a column of cells. Some of them have numbers in them and some have the word 'Oyster'. I want a formula which tells me have many cells in the range have the word 'Oyster' in them.

4. ## Re: How do i get excel to count the number of times a word appears in a range of cells?

TRY
=COUNTIF(A1:A100,"*Oyster*")
OR
=COUNTIF(A1:A100,"Oyster")

5. ## Re: How do i get excel to count the number of times a word appears in a range of cells?

It's OK, I have now worked it out myself. Thanks.

#### Thread Information

##### Users Browsing this Thread

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