| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Register Balance | Excel Discussion (Misc queries) | |||
| Check register running balance to another worksheet | Excel Worksheet Functions | |||
| Balance Forward - Worksheet Set up | Excel Worksheet Functions | |||
| Getting the Check Register Balance to show on another Sheet | Excel Worksheet Functions | |||
| how : check register running balance is a stationary cell | Excel Discussion (Misc queries) | |||
Linear Mode
