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)?


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 '15 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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