title: Count if excel not working for letter C
body: <p>My <code>count if</code> function won't work for the letter "C". I checked for spaces with <code>len</code> function and I am super confused. Thanks for the help.    </p>
  
  <pre><code>    #of Accident Type   
  A   28
  B   19
  C   =COUNTIF(A2:A101, "*C*")
  D   17
  E   9
  F   9
  
  Accidents
  A
  B
  D
  A
  A
  F
  C
  A
  C
  B
  E
  B
  A
  C
  F
  D
  B
  C
  D
  A
  A
  C
  B
  E
  B
  C
  E
  A
  B
  A
  A
  A
  B
  C
  C
  D
  F
  D
  B
  B
  A
  F
  C
  B
  A
  C
  B
  E
  E
  D
  A
  B
  C
  E
  A
  A
  F
  C
  B
  D
  D
  D
  B
  D
  C
  A
  F
  A
  A
  B
  D
  E
  A
  E
  D
  B
  C
  A
  F
  A
  C
  D
  D
  A
  A
  B
  A
  F
  D
  C
  A
  C
  B
  F
  D
  A
  E
  A
  C
  D
  </code></pre>