CODEWITHSUNDEEP
excelgoogle-sheetsexcel-formulasum
Bert Starington
Bert Starington

Reputation: 61

Google sheets, calculate sum if the cell above the formula is not empty

The title explains everything.

What I have so far:

=SUMIF(COUNTA(C4!=N(C4*Sheet2!H1-Sheet2!E4-A3)))

Original formula:

=sum(C4*Sheet2!H1-Sheet2!E4-A3)

So the formula is in cell C5, I want the the code to execute only if the cell above it has a value.

Upvotes: 0

Views: 854

Answers (1)

Akshin Jalilov
Akshin Jalilov

Reputation: 1716

Try

=IF(ISBLANK(C4), ,sum(C4*Sheet2!H1-Sheet2!E4-A3))

Upvotes: 1

Related Questions