How do I get balance forward to work in check register?
 

I have gotten the cells in columns to add, subtract and balance. Problem is
I can't seem to get the right formula to go from row to row so that there is
a running balance. Any suggestions?

How do I get balance forward to work in check register?
 

I have my balance in a different column with a formula like this:
=Sum(A:A)

Then in column A I enter deposits and withdrawals (of course
withdrawals are preceded by the negative sign).

I have also seen people use 3 columns to do this:
Column A = Deposits
Column B = Withdrawals
Column C = Running Balance
Cell C3 Formula = "=Offset(C3,-1,0)+A3-B3"
The offset prevents errors from deleting the reference rows.

HTH

Charles

Frieda wrote:
I have gotten the cells in columns to add, subtract and balance. Problem is
I can't seem to get the right formula to go from row to row so that there is
a running balance. Any suggestions?

How do I get balance forward to work in check register?
 

=sum(a2:$a$2), you can copy this and it is anchored in one spot only
--
David


"Frieda" wrote:

I have gotten the cells in columns to add, subtract and balance. Problem is
I can't seem to get the right formula to go from row to row so that there is
a running balance. Any suggestions?