I simply get mad trying and trying again to find the right function that may help me to count out of an array only the cells that contain both given keywords (in this case Mark and Luke).
This is my last try:
"...Your function works perfectly only if you substitute FIND with SEARCH:..."
The difference between these functions in Excel is that the FIND is case-sensitive and the SEARCH does not differentiate.
Depending on your data one of them will actually be more suitable for the correct use.
"...Besides, I have found an additional function, much simpler than expected:
Are you sure that this formula is providing the correct result?
If in your data will always appear the word luke before the word mark this formula works.
But if any case appears in different order the words the formula will not count.
This is not the case with the formula I suggested earlier.
I hope it helps.
Belo Horizonte, Brasil.