Counting occurrences of words

Hello Martin,

Thank you for your question regarding how to count occurences of words in an array of cells in Excel.

Select a cell where you require the result to appear and use the following formula:

=COUNTIF(Array,"*word*")

Replace the word array with the range where the words are located. Replace the next part with the word you are trying to count. I have used the * wildcard since the word may be anywhere in a cell.

Give this a try!!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer