Excel: count of words in multiple cell range


I am working on the spreadsheet which contains different words in cells range and I would like to count only particular combination of the word, here we go, example: I only would like to count entries which includes: ended and multiple and last. I have tried countifs formula but I got to the point where I counted all entries with ended, multiple, last. Please bear in mind that some of the cells are empty. I would be really appreciated of your help. Many thanks.j.

Customer service ended service was multiple/single last entry
1 ended Multiple last
2 Multiple last
3 ended Multiple last
4 ended Single last
5 Single
6 Ended Single last
7 Ended Multiple
8 Multiple Last
9 ended Multiple Last


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of September 27, 2014.


For more resources for Microsoft Excel