title: Google Spreadsheet, filter doesn't allow wildcards? How to countif multiple columns with wildcards?
body: <p>When I do:</p>
  
  <pre><code>B         C
  223 herp
  223 herp
  3   herp
  223 derp
  223 herp,derp
  
  =countif(C:C, "*herp*")
  </code></pre>
  
  <p>I correctly get 4. </p>
  
  <p>When I do</p>
  
  <pre><code>=count(filter(B:B, B:B=223, C:C="*herp*"))
  </code></pre>
  
  <p>I incorrectly get 0.  When I remove the "*" wildcard characters, I get 2, which is better, but doesn't get herp,derp.</p>
  
  <p>Does filter not support wildcard characters?  If so, how can I count a row only if two of it's columns meet two different criteria which have wildcards?</p>