With this kind of Google Docs Spreadsheet:

enter image description here

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

1 Answer 1


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:

  • Perfect, just does the trick! :)
    – kontur
    Oct 1, 2015 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.