title: Google Spreadsheet: ArrayFormula and Filter
body: <p>I realize that there are multiple questions with this title, but I don't understand the answers to them, or it is not directly related to my issue.</p>
  
  <p>I'm trying to avoid manually "dragging" a formula to duplicate it for each row.</p>
  
  <p>Formula looks like this</p>
  
  <pre><code>=IF(ISBLANK(A6), 
      "", 
      COUNT(FILTER(Data!C$2:C, 
                   Data!A$2:A = A6, 
                   Data!B$2:B &gt;= B$2, 
                   Data!B$2:B &lt;= B$3, 
                   Data!C$2:C &gt;= E$3, 
                   Data!C$2:C &lt;= E$2)))
  </code></pre>
  
  <p>I'm not sure all the anchors are needed when using <code>ARRAYFORMULA</code>.</p>
  
  <p>The <code>A</code> column is the one I want to "interate", the rest of the ranges should evaluate to whatever they're evaluating to now.</p>
  
  <p>I have tried this:</p>
  
  <pre><code>=ARRAYFORMULA(IF(ISBLANK(A6:A), 
                "", 
                COUNT(FILTER(Data!C$2:C, 
                             Data!A$2:A = A6:A, 
                             Data!B$2:B &gt;= B$2, 
                             Data!B$2:B &lt;= B$3, 
                             Data!C$2:C &gt;= E$3,
                             Data!C$2:C &lt;= E$2))))
  </code></pre>
  
  <p>In which the <code>A6:A</code> seems to evaluate correctly to each cell in the <code>A</code> column. However, the ranges from the <code>Data</code> sheet also seem to evaluate to a single value and not the ranges.</p>
  
  <p>Am I missing something or do I not understand how <code>ARRAYFORMULA</code> works?</p>