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?
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?
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?
=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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks