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 1 2 3 4 5 6 7 8 9
This question generated 11 answers. To proceed to the answers, click here.