View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default 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?