title: Using SUMIFS with multiple AND OR conditions
body: <p>I would like to create a succinct Excel formula that SUMS a column based on a set of AND conditions, plus a set of OR conditions.</p>
  
  <p>My Excel table contains the following data and I used defined names for the columns.</p>
  
  <ul>
  <li>Quote_Value (Worksheet!$A:$A) holds an accounting value.</li>
  <li>Days_To_Close (Worksheet!$B:$B) contains a formula that results in a number.</li>
  <li>Salesman (Worksheet!$C:$C) contains text and is a name.</li>
  <li>Quote_Month (Worksheet!$D:$D) contains a formula (=TEXT(Worksheet!$E:$E,"mmm-yy"))to convert a date/time number from another column into a text based month reference.</li>
  </ul>
  
  <p>I want to SUM Quote_Value if Salesman equals JBloggs and Days_To_Close is equal to or less than 90 and Quote_Month is equal to one of the following (Oct-13, Nov-13, or Dec-13).</p>
  
  <p>At the moment, I've got this to work but it includes a lot of repetition, which I don't think I need.</p>
  
  <pre><code>=SUM(SUMIFS(Quote_Value,Salesman,"=JBloggs",Days_To_Close,"&lt;=90",Quote_Month,"=Oct-13")+SUMIFS(Quote_Value,Salesman,"=JBloggs",Days_To_Close,"&lt;=90",Quote_Month,"=Nov-13")+SUMIFS(Quote_Value,Salesman,"=JBloggs",Days_To_Close,"&lt;=90",Quote_Month,"=Dec-13"))
  </code></pre>
  
  <p>What I'd like to do is something more like the following but I can't work out the correct syntax:</p>
  
  <pre><code>=SUMIFS(Quote_Value,Salesman,"=JBloggs",Days_To_Close,"&lt;=90",Quote_Month,OR(Quote_Month="Oct-13",Quote_Month="Nov-13",Quote_Month="Dec-13"))
  </code></pre>
  
  <p>That formula doesn't error, it just returns a 0 value. Yet if I manually examine the data, that's not correct. I even tried using TRIM(Quote_Month) to make sure that spaces hadn't crept into the data but the fact that my extended SUM formula works indicates that the data is OK and that it's a syntax issue. Can anybody steer me in the right direction?</p>