Counting cells with partial text
I need to count cells that contain at least a certain word or entry, but not
neccesserily just that word. For example:
1) he she it
2) he it
3) she it
I would like to get 2 if I count "he" or "she", and 3 if I count "it"
Thank you very much!
|