You are here: HomeExcelTutorials

# how to count if cell "contains" a word

## how to count if cell "contains" a word

Price: FREE

(Using Excel2003/WinXP) I am trying to count the number of times 2 values are in a cell. The string may contain the values ",abcd, ab cf," or ",ab cf, abcd," The other part that's stumping me is the string could be ",abcd, ab cf, ab cg," (or longer). I am wanting to know the number of times the cell contains "abcd" and "ab cf" no matter what order it's in. I will try to show an example below:
1,abcd,
2 ,abcd, ab cf,
3 ,abcd, ab cf, ab cg,
4 ,abcd, ab cg,
5 ,ab cf, abcd,
I would want to include cell 2, cell 3, and cell 5 in my count, but not 1 or 4. Can I do this?

Visit publisher's web-site: how to count if cell "contains" a word

Category and Tags: ExcelTutorials : : Functions

## Related Tutorials

### How to count a specific word in one cell?

Free: Yes
Tags: Excel ›

If A1 has value "Two plus Two makes four"
and A2 has value "Two", the required answer (counting the specific word (Two) in this case) should be 2.
Please provide formula to achieve this.

### True Word Count

Free: Yes
Tags: Excel ›

I am trying to find the "true" word count of a cell. Please see attached file. I need it to exclude any numbers, characters, etc, just count real words.
Formula IF(LEN(TRIM(A2))=0,0,LEN(TRIM(A2))-LEN(SUBSTITUTE(A2," ",""))+1) returned 9, but it should return 6, when counts only # of real words.

### how to count occurences of word in spreadsheet formula

Free: Yes
Tags: Excel › Functions

I need to count the number of times specific words appear in a sheet , I'm not having much luck on my own as the word might be within the cell but not constitute the whole contents.
i.e looking for the word DOG in cell containing "the dog sat down"

### count how many rows a word appears in

Free: Yes
Tags: Excel ›

I have an excel spreadsheet, say 200 rows by one column. I am looking to count how many cells the word "over achievement" appears in.
some cells say "over achievement Q1"
some cells say "over achievement bonus"
some cells say "overachieve growth"
Say the word over achievement 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?

### Need Excel count of 1 word if found in multi-word cells of column

Free: Yes
Tags: Excel ›

I need a function that tests whether a cell containing multiple words includes certain text. For example, test for the occurrence of the string "alarm" and give me a count. One spreadsheet cell contains all of the following text:
The event alarmed 3 times with 1 alarm being critical.
The text string "alarm" actually appears twice in that statement, one of which was a word. What two sets of syntax will allow me to capture both conditions.a string match or a word match.

## Related Applications & Scripts

### Limit and Count characters in textarea while typing

Free: Yes
Tags: JavaScript › Excel Forms

A very simple and powerfull Count down field character in javascript !!!!
Useful for contact form or any type of forms.

### Word Document Repairing Tool

Free: No
Tags: Software › Excel Data Recovery Word

Advanced Word Repair (AWR) is the best Word recovery tool in the world. It uses advanced technologies to scan the corrupt or damaged Microsoft Word documents(.doc files) and recover your data in them as much as possible, so to minimize the loss in file corruption.

### Tell a friend

Free: No
Tags: Flash › Excel Miscellaneous

Word of mouth is considered a reliable source compared to other ways of advertisement. Let your visitors promote your website using your "tell a friend" module. Create a lasting first impression and employ the latest interactive technology available. The "tell a friend" can be amended and customized visually although layout changes may have some restrictions.

### JavaScript countdown script

Free: Yes
Tags: JavaScript › Excel Date and Time

This is a "universal" count down script that lets you count down to absolute events whereby the target date/time needs to be specific to a certain time zone, such as the date/time of the next Solar Eclipse.