Counting Specific word text

[excelimprove]

Can you combine "CountA" with "IF" and how is this done?

I need to find the number of occurrences of a specific word, i.e., "textbook" in a specified group of cells.

Thank you.

 

[Marcelo Branco]

Maybe COUNTIF can help

http://office.microsoft.com/en-us/excel-help/countif-HP005209029.aspx

M.

 

[excelimprove]

<TABLE id=NestedTable2 class=collapse name="NestedTable2"><TBODY><TR class=trbgodd><TD>=COUNTIF(A2:A5,"apples")</TD><TD>Number of cells with apples in the first column above (2)</TD></TR></TBODY></TABLE>

This was exactly what I needed - it works!!!

Thank you for your speedy reply, MrExcel!!!