title: OpenOffice.org Calc SUMIF statement
body: <p>I'm trying to sum all cells in C2:C2000 if the corresponding cell in column A is in (10; 20], but I'm having problems with the condition.</p>
  
  <p>I've tried something like <code>=SUMIF(A2:A2000, AND("&gt;10","&lt;=20"), C2:C2000)</code>, but that returns 0 which is incorrect.</p>
  
  <p>Thanks.</p>
  
  <p>[edit]</p>
  
  <p>It is possible to use <code>=SUMIF(A2:A2000, "&gt;10", C2:C2000) - SUMIF(A2:A2000, "&gt;20", C2:C2000)</code> but that's not exactly what I'm looking for.</p>