title: Excel DSUM - using AND/OR as part of the criteria
body: <p>I checked all the Dsum questions and they did not answer mine. </p>
  
  <p>I have a DSUM formula in my spreadsheet that looks like this - =DSUM(Sheet1!$A:$L, Sheet3!$I1, Sheet3!$A1:$J2). A1 to J2 in Sheet 3 is a set of fields with corresponding values that the function tests against. </p>
  
  <pre><code>Name    Status  Ops Grade   Score   Amount  Date    Sum Description
           FAC                        BUDGET  1/1/2012        
  </code></pre>
  
  <p>Now my issue is I need to exclude certain names from the sum. I worked around by including another column in B1 that excludes all names with 'AL' in them. This is not scalable as I'm forced to create a column for each combination that needs to be excluded. </p>
  
  <pre><code>Name    Name    Status  Ops Grade   Score   Amount  Date    Sum Description
         &lt;&gt;*AL*   FAC                         BUDGET  1/1/2012        
  </code></pre>
  
  <p>Is it possible to include OR/AND in the Name values? e.g. =&lt;>*80*or &lt;>AB* or &lt;>()* etc?</p>
  
  <p>Thanks.</p>