Summation Formula

[raj_sidhu2008]

Hello,

I am new to Excel. Can someone kindly advise me the formula for below? I am trying to have a running total of the values in column C by adding B and subtracting A. However, I run into a problem when the cell in C is empty and Excel treats it as "0" and starts returning incorrect values. If the cell is '0', I want Excel to consider the value in the cell one above. Please help.

 

[Deek6t8]

You could use a formula like the below but it would fail if there were 2 blank rows in column C,
=if(C2="",C1+B2-A2,C2+B2-A2)

I would instead use the second formula below
In top row have =C1+B1-A1
In other rows have =D1+C2+B2-A2 to give a running total

 

[Alex Blakenburg]

I don't understand why your running total suddenly drops to the 62k.
Ignoring that see if this is what you had in mind.

20230120 Running total balance raj_sidhu2008.xlsx
	A	B	C
1	Dr	Cr	Balance
2	0/Bal		3,317,183.80
3		50,000.00	3,367,183.80
4	5,000.00		3,362,183.80
5	5,000.00		3,357,183.80
6
7		5,000.00	3,362,183.80
8
9	300.00		3,361,883.80
10	600.00		3,361,283.80
Data

Cell Formulas
Range	Formula
C3:C10	C3	=IF(COUNT(A3:B3)=0,"", IF(C2="", INDEX(C$1:C2,MATCH(2,1/(C$1:C2<>""),1),0)+B3-A3, C2+B3-A3 ) )