Google Sheets – Using SUMIF or IF When Sum Is More Than Zero

formulasgoogle sheets

In Google Sheets, I would like to get – at the bottom-most cell of a column – the sum of each cell (except for row 1, the header) above in that column ONLY if the total is greater than zero, (I don't want to see 0's when the column is blank). Can I do that with a SUMIF function, (if yes, how?) or, I need to use an IF function?

Best Answer

paste into any cell of A column:

=IF(SUM(INDIRECT("A2:A"&ROW()-1))>0, SUM(INDIRECT("A2:A"&ROW()-1)), )

Related Solutions

Google Sheets – Sum of Two Numbers with a Minimum of Zero

You can use the MAX function for this, since

MAX( A3+B3, 0 )

will return 0, when the sum is negative.

Google-sheets – Error using “sumif” together with “address” function

The problem is that address returns a string, so you need to turn that string into a reference.

Try this:

=sumif(indirect(address(F2,G2,2)&":"&address(ROW(B2),COLUMN(B2))),B2,indirect(address(F2,H2,2)&":"&address(ROW(C2),COLUMN(C2))))

Best Answer

Related Solutions

Google Sheets – Sum of Two Numbers with a Minimum of Zero

Google-sheets – Error using “sumif” together with “address” function

Related Topic