To count the number of cells containing the contents of the Text cell (and nothing else), you can use the COUNTIF function as the following formula demonstrates.

=COUNTIF(Data,Text)

For example, if the Text cell contains the string “Alpha” the formula returns 2 because two cells in the Data range contain this text. This formula is not case sensitive, so it counts both “Alpha” (cell A2) and “alpha” (cell A10).

Note, however, that it does not count the cell that contains “Alpha Beta” (cell A8). The following array formula is similar to the preceding formula, but this one is case sensitive:

{=SUM(IF(EXACT(Data,Text),1))}

• 1200 Calorie Diet Review This is a diet that is based on consuming only 1200 calories in day is minimum considered safe for weight...
• DVD Review: 'Your Instructional Marine Aquarium Guide' This DVD is presented by Paul Talbot, produced by Fish Eye Films and can be purchased from Exclusive Fish Films....
• Excellent Stem Cell Mobilization and Safety Profile for TG-0054 TaiGen Biotechnology Co., Ltd. announced today that in a phase 1 study in healthy volunteers TG-0054, a chemokine receptor CXCR4...
• Make Blogging Work for Your Business pt 1 Are you ready to make blogging work for your business? If you already know the benefits associated with corporate blogging,...
• Excel Tip: Have Your Cell Contents = Tab Names It's time for another edition of Stupid Excel Tricks! One of my coworkers recently asked me an Excel question.  He...