Google sheets dsum on blank column criterion

1
votes

I'm messing around with google sheets trying to track a goal.

I'd like to run a DSUM() where one of the criteria is that a column is blank.

I have tried "", but that isn't working.

I'm trying to get DSUM(A:C, Goal, ) to equal 2 (sums the second column, but not the first) for the following data:

Goal   | Met   | Rewarded
------------------------
1      | 1 Jan | 2 Jan
2      | 3 Jan |
3      |       |

Where criterion range is:

Met   | Rewarded
------------------------
>0    | ""

Anyone know how to set the criterion for a blank column? Or use a function like ISBLANK?

2
arraysgoogle-sheetssumgoogle-sheets-formula

2 Answers

3
votes

try it with escaping the equal sign:

'=

enter image description here

enter image description here

0
votes

You can try the following formula

=DSUM({B2:C6,{D2;ArrayFormula(IFERROR(D3:D6*1,""))}},"Goal",B8:D9)

By using {D2;ArrayFormula(IFERROR(D3:D6*1,""))} we turn all blank cells to zeros. So changing the Rewarded criterion from "" to 0 we get the expected results.

enter image description here