title: Google Sheets Error "Array Arguments to SUMIFS are of different size"
body: <p>Converting from an Excel file (where this works fine), I have a SUMIFS formula that is returning an error "Array Arguments to SUMIFS are of different size".  The formula in question looks like this:</p>
  
  <pre><code>=SUMIFS($G9:$EA9,$F$2:$DZ$2,"&gt;=1/1/"&amp;A$2,$F$2:$DZ$2,"&lt;=12/31/"&amp;A$2)
  </code></pre>
  
  <p>The array arguments are:</p>
  
  <ul>
  <li>G9:EA9 - 125 columns, 1 row</li>
  <li>F2:DZ2 - 125 columns, 1 row</li>
  <li>F2:DZ2 - 125 columns, 1 row</li>
  </ul>
  
  <p>The criteria arguments are values.  I'm not looking for a workaround or hack - just want to know if I'm somehow misusing the SUMIFS formula so I can maintain consistency with Excel</p>