title: Google Docs using multiple manual criterion in DSUM
body: <p>How can I manually enter multiple criterion into a DSUM function?</p>
  
  <p>I can have it check a single set of criterion with: <code>=DSUM(J3:L55, "Charge", {"Category";"Coffee"})</code></p>
  
  <p>However changing that to <code>=DSUM(J3:L55, "Charge", {"Category";"Coffee";"Split";"Yes"}</code> Causes it to just use the <code>"Category";"Coffee"</code> but and ignore the <code>;"Split";"Yes"</code> section.</p>
  
  <p>What is the syntax to set multiple criterion in google docs? I cannot really make a 2x2 table to each category I have (<code>=DSUM(J3:L55, "Charge", D7:E8)</code> ) and instead need to just manually enter the criterion.</p>
  
  <p><img src="https://i.stack.imgur.com/KTlfO.png" alt="DSUM with table criterion is in blue"></p>
  
  <p>DSUM with table criterion is in blue. I am selecting "Category" though "Split?" and want to use both Category and Split as criterion without having to resort to the darker blue table you see there</p>