title: Count number of occurrences based on 2 conditions or Regexp
body: <p>How can I get the number of occurrences for some range based on </p>
  
  <ol>
  <li><p>A regular expression</p></li>
  <li><p>2+ conditions; let's say cells that contain "yes" and / or "no"</p></li>
  </ol>
  
  <p>What I've got for the moment: </p>
  
  <pre><code>COUNTIF(B5:O5; "*yes*")
  </code></pre>
  
  <p>I tried to use <code>COUNTIF(B5:O5; {"*yes*", "*no*"})</code> or <code>COUNTIF(B5:O5; "(*yes*)|(*no*)")</code>, but neither of them worked.</p>
  
  <p>Or, how do I count cells that contain some domain names&mdash;yahoo.com, hotmail.com, and gmail.com&mdash;using regexp? e.g.: </p>
  
  <pre><code>(\W|^)[\w.+\-]{0,25}@(yahoo|hotmail|gmail)\.com(\W|$)
  </code></pre>