View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Makaron Makaron is offline
external usenet poster
 
Posts: 14
Default 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!