running balance

[PR Kid]

How can I have the running balance show up as I plug in number without it
showing the balance down the entire colunm if I use =b2+c2+c1 as the formula

=b3+c3+c2 and so on.
ie
A B C
Day Reg hrs OT Running Total hrs
1 10 1 11
2 9 0 20
4 0

 

[Sandy Mann]

=IF(COUNT(B3:C3)=2,B3+C3+C2,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

My formula assumed that you will always be entering zero for no OT hours, it
not use:

=IF(Count(B3:C3)>0,B3+C3+C2,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk