Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count how many rows a word appears in
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. -- Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count how many rows a word appears in
You can do it like this:
=COUNTIF(A1:A200,"*overachievement*") Hope this helps. Pete "learningaccess" wrote in message ... 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. -- Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count how many times the same word appears in column | Excel Discussion (Misc queries) | |||
counting the number of times a word appears | Excel Worksheet Functions | |||
how to search a word in a excel file which appears twice | Excel Worksheet Functions | |||
How can I count the # of times the word "Yes" appears in a range | Excel Worksheet Functions | |||
count the number of times a specific word appears in a column | Excel Worksheet Functions |