How do I bypass blank cells with new value

[_dave]

Sum with Blank Cell.ods (12.5 KB)
I’m created a so-call reference balance sheet and I cannot figure out how continue the sum if a cell is blank.

In the sample I have not received a bill for the electric just yet, so that cell is blank.
How do I continue the balance if another expense is listed below the blank cell?

Thanks ahead for any solutions or work-around.

[_dave]

Thank you to both PKG and eeigor, I mark PKG as the solution I wanted for it give me the current balance as well.

[PKG]

D4: =IF(C4="";"";D$3-SUM(C$4:C4))

Sum with Blank Cell (2).ods (10,9 KB)

[eeigor]

Handling of Empty Cells
Repaired:
D7: =IF(ISBLANK(C7);0;D6-C7)
Sum with Blank Cell.ods (15.3 KB)
Enter 0 to debit the electricity bill.