title: Excel DSUM with multiple criteria
body: <p>I'm pretty new to Excel. Here is the code </p>
  
  <pre><code>=DSUM(Table_1,"column1",INDIRECT(INDIRECT(ADDRESS(MATCH($C9,Names!B:B,0), 1, 1, , "Names"))))
  </code></pre>
  
  <p>which sums up all the values of column1 inside Table_1 with the matched criteria. However, if I would like to add another criteria say Table1_column_amount=1 to the DSUM, how would I possibly do that?</p>
  
  <p>any help would be appreciated. </p>