Google Docs using multiple manual criterion in DSUM

google-docs
Douglas Gaskell picture Douglas Gaskell · Nov 4, 2014 · Viewed 11.2k times · Source

How can I manually enter multiple criterion into a DSUM function?

I can have it check a single set of criterion with: =DSUM(J3:L55, "Charge", {"Category";"Coffee"})

However changing that to =DSUM(J3:L55, "Charge", {"Category";"Coffee";"Split";"Yes"} Causes it to just use the "Category";"Coffee" but and ignore the ;"Split";"Yes" section.

What is the syntax to set multiple criterion in google docs? I cannot really make a 2x2 table to each category I have (=DSUM(J3:L55, "Charge", D7:E8) ) and instead need to just manually enter the criterion.

DSUM with table criterion is in blue

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

Answer

wim1969 picture wim1969 · Oct 16, 2015

Try

=DSUM(J3:L55, "Charge", {{"Category";"Coffee"},{"Split";"Yes"}})

Related questions

wget/curl large file from google drive

I'm trying to download a file from google drive in a script, and I'm having a little trouble doing so. The files I'm trying to download are here. I've looked online extensively and I finally managed to get one of …

Read More
How to turn off page breaks in Google Docs?

How do I turn off page breaks in Google Docs so I just have a single continuous scrolling document? I don't think this method applies anymore. I never want to print out my Google Docs. The page breaks are distracting …

Read More
How To Format A Block of Code Within a Presentation?

I am preparing a presentation using Google Slides, though I can also work on the presentation within Open Office that will include code snippets. Is there any easy way to perform basic syntax highlighting on the code snippets with either …

Read More