title: How can I set multiple criterias for a Google Spreadsheet SumIF formula?
body: <p>I want a formula which sums column <code>D</code> if column <code>K</code> has a value between 3000 and 4000. I've tried the following but none work:</p>
  
  <pre><code>=SUMIF(K3:K67; "&gt;= 3000 &amp; &lt; 4000";D3:D67)
  =SUMIF(K3:K67; "&gt;= 3000 " &amp; " &lt; 4000";D3:D67)
  =SUMIF(K3:K67; "&gt;= 3000 AND &lt; 4000";D3:D67)
  </code></pre>
  
  <p>Is this possible or must I use the ArrayFormula function (which I don't understand) like in <a href="https://stackoverflow.com/questions/10635029/multiple-criteria-for-sumif-google-spreadsheet">this question</a>? </p>
  
  <p><strong>Edit:</strong> This works, so there's nothing wrong with the data:</p>
  
  <pre><code>=SUMIF(K3:K67; "&gt;= 3000";D3:D67)
  </code></pre>