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.
<tbody>
</tbody>
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>