View Single Post
  #1   Report Post  
Tuc
 
Posts: n/a
Default countif question

Hi,

I'm struggling with an issue that might be easy for someone else. I need to
count all the rows where column A has the number 11 and column B contains a
word, let's say the word 'hockey'. Column B is a text column that will have
multiple words in it, so I need to search for 'hockey' using wildcards, i.e.
'*hockey*'. Any thoughts?
Thanks!