count of words in multiple cell range

[Justyna82]

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

<tbody>
</tbody>

 

[Rick Rothstein]

I actually noticed other error or rather mistake in my other formula, example of the current results below. i used this formula: =if(a2=a1, "multiple", if(a2=a3,"multiple","single")) However this formula brings incorrectly multiples

Try this formula in B2 and copied down instead..

=IF(A2=A1,"Multiple",IF(AND(A2<>A1,A2<>A3),"Single","Multiple"))