Hey everyone! I’m trying to figure out how to use multiple manual criteria in a DSUM function in Google Sheets. I know how to use a single criterion like this:
=DSUM(B2:D60, "Total", {"Category";"Food"})
But when I attempt to add another one like so:
=DSUM(B2:D60, "Total", {"Category";"Food";"Status";"Confirmed"})
It still only considers the first criterion and ignores the second. Is there a way to include both criteria directly within the function without having to create a separate table? Any suggestions would be greatly appreciated!
yo, i had the same issue! try this:
=DSUM(B2:D60, “Total”, {“Category”,“Food”;“Status”,“Confirmed”})
its all about those commas and semicolons. gotta put em in the right spots. works like a charm for me. good luck!
I’ve dealt with this exact issue before, and I can tell you it’s a bit tricky but doable. The key is to use an array constant for your criteria range. Here’s how I got it working:
=DSUM(B2:D60, “Total”, {“Category”,“Food”;“Status”,“Confirmed”})
Notice the change in the criteria syntax. You need to separate the column names and their corresponding values with commas, and use semicolons to separate different criteria. This way, Google Sheets understands you’re applying multiple conditions.
Also, make sure your column names in the criteria exactly match those in your data range. It’s case-sensitive, so “category” won’t work if your column is named “Category”.
Hope this helps solve your problem. Let me know if you need any clarification!