title: COUNTIF returns 0 when expected 1
body: <pre><code>=IF(COUNTIF(A28:AJ28,"*"&amp;automation&amp;"*")
  , "need", "no need")
  </code></pre>
  
  <p>i expect this formula to return <code>'need'</code>
   but i get <code>'no need'</code>.</p>
  
  <p>how should I change it?</p>
  
  <p><a href="https://i.stack.imgur.com/R1Ukd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/R1Ukd.png" alt="enter image description here"></a></p>