Google Sheets – Sum Column with Boolean Secondary Column

google docsgoogle sheets

With this kind of Google Docs Spreadsheet:

How can I calculate SUM(C1:C8), but without values where the corresponding D column has a 0 (so, without C1 and C3)?

Try the following formula:

=SUMIF(D1:D8, "<>0", C1:C8)

Not described in the help is the use of <>. This reads as not equal

The rest is explained in the help:

Replace ISEMPTY with ISBLANK

Your formula should be as follows:-

=SUM(FILTER(A:A, ISBLANK(B:B)))

Now you will get the result as 40

This works, see F35 in your sheet:

SUMIF(E2:E33;">="&E35;B2:B33)-SUMIF(E2:E33;"<="&E36;B2:B33)

column E is done by calculating a value for the dates to be able to compare them (=VALUE(E1))

Note that separating the args for some reasons is done with ;