Using SUMIF correctly on google spreadsheet

excel google-docs
user28790 picture user28790 · Sep 28, 2013 · Viewed 22.6k times · Source

I want a cell to give me the sums of the cells above, only when another column has values in it as well. For instance, I want B5 to sum up B1:B4, only when C1:C4 also have values, if a C cell doesn't have a value, then I want the corresponding B cell to be counted as a 0 during the sum. I looking up info on SumIf and FILTER but I don't know what to put in the criteria to make it accept any number, and how to report 0 when no number is available. Any help would be appreciated.

What I tried doing so far: =FILTER(B1:B4;C1:C4=value() and I get an error

Answer

Jerry picture Jerry · Sep 28, 2013

Have you tried using SUMIF like this:

=SUMIF(C1:C4, "<>", B1:B4)

?

It's working for me.

Related questions

JSON import to Excel

Is it possible to script JSON calls in a macro? I want to get a JSON string through an API connection. It looks like the problem is Excel expects the parameters to be passed in the HTML-string, but JSON passes …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More