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

1. ## 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?

2. ## Re: 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?

3. ## RE: 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?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1