To count the number of cells that contain a string that includes the contents of the Text cell, use this formula:

=COUNTIF(Data,”*”&Text&”*”)

For example, if the Text cell contains the text “Alpha” the formula returns 3 because three cells in the Data range contain the text “alpha” (cells A2, A8, and A10). Note that the comparison is not case sensitive.

If you need a case-sensitive count, you can use the following array formula:

{=SUM(IF(LEN(Data)-LEN(SUBSTITUTE(Data,Text,””))>0,1))}

If the Text cells contain the text “Alpha” the preceding formula returns 2 because the string appears in two cells (A2 and A8).

• Text Messaging is the Biggest Scam of the 21st Century Readers: The following post is lengthy to say the least.  The point of the post is obvious, what I do...
• Stem Cells, the power to divide In the beginning, one cell becomes two, and two become four. Being fruitful, they multiply into a ball of many...
• Placentas may offer richer source for stem cells Image via Wikipedia Researchers in the U.S. say they may have found a new and better source for harvesting stem...
• ITALY - Study: Tumor Stem Cells Key in Fighting Cancer Image by hoodiefanatic via Flickr The key to eradicating tumors and preventing relapses and metastasis is buried within the tumor...
• 4Info review A few years ago, I changed cell phone plans. I decided to save a few bucks and went with a...