count how many rows a word appears in

L

learningaccess

Hi.

I have an excel spreadsheet, say 200 rows by one column. I am looking to
count how many cells the word "overachievement" appears in.
some cells say "overachievement Q1"
some cells say "overachievement bonus"
some cells say "overacheivement growth"

Say the word overachievement appears in 50 rows in combination with other
words. I want a count of how many times the word appears in a range of cells
even though the cells are different.

Is there a way to count that? Please let me know. Urgent! Thanks.
 
P

Pete_UK

You can do it like this:

=COUNTIF(A1:A200,"*overachievement*")

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count a word recurrent in many cells 1
count frequency of a word in range of cells 2
How to count the numbers in a Word document? 0
Function in Excel to count and list number of entries of text valuesin a row. 2
Insert name and adress from a list in a word document 1
Wysiwyg in Word 0
Create a chart from a table in word thats dynamic 0
Need Help with a VBA subroutine 0

Top