title: Excel countifs #VALUE error
body: <p>I'm getting the #VALUE error when running the following formula.
  I've run separate countIF statements and they work fine on their own but combined it's erroring out. I am guessing it is because the first range is a single column and the second is across multiple columns? Stumped.</p>
  
  <pre><code>=COUNTIFS(Data!G3:G2000,"&gt;"&amp;$B$8, Data!C3:D2000,$B$2)
  </code></pre>
  
  <p>Data!G column are numbers, with B8 being a number I'll enter.
  Data!C:D is text, with B2 being text I'll enter.</p>