title: Excel SUMIFS with Ranges as Criteria
body: <p>I'm having some issues getting SUMIFS to do what I want (maybe because it cannot). Here's exactly what I'm trying to setup:</p>
  
  <ul>
  <li>Sheet with denormalized data (server, files by extensions, counts, sizes)</li>
  <li>Sheet with rows of strings (server names)</li>
  <li>Sheet with rows of string + formula</li>
  </ul>
  
  <p>Basically I'm trying to look at how the data on my various data servers is bucketed. So I have a list of extensions that I care about (let's say .docx, .xlsx, and .pptx) and a list of servers I care about (let's say serv_a, serv_b, and serv_c). Given the massive worksheet I have with all the data from all the servers and all the files I need to get the count of files on the server which have extensions that I care about.</p>
  
  <p>Here's the formula I'm using now (it is not working)</p>
  
  <pre><code>  =SUMIFS(data!$C:$C, data!$A:$A, A2, data!$B:$B, filter!$A:$A)
  </code></pre>
  
  <p>Where data!$C is the count of a extension on a server, data!$A is the server name, A2 is server name I want to filter on, and filter!$A is the list of extensions I want to filter on.</p>
  
  <p>I do think it's the LIST of extensions to filter by which is breaking things. Given a single value (.docx) I can count 143,567 files on a given server, but the query returns 1.</p>
  
  <p>Thanks!</p>