Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I'm making a table to keep track of deposits, credits, etc for a bank
account, with a running balance. Here is the basic layout: Column b = date of entry Column c = credits Column d = deposits Column e = bank fees [ Column F & G = other info, not relevant here ] Column H = Running balance Each row/entry will be a single transaction. It may have the same date as another entry, because there might be several deposits, credits, bank fees on a given day. So for example, there might be 3 entries on 7/25/07. But for each entry, only 1 of C-D-E will have a number-value for a given entry. I'd like to have column H look at c, d, and e and add or subtract whichever one has info in it from the previous cell in Column H. I was thinking that I could make H have a formula that would say "Subtract the sum-total of C-D-E from the previous cell". But I can't figure out how to do this. Any relatively easy way to do this, or otherwise achieve my goal of a running balance that auto-corrects as I add/delete entries over time? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a running total (balance) in a pivot table? | Excel Worksheet Functions | |||
TABLE W/RUNNING BALANCE | Excel Discussion (Misc queries) | |||
TABLE WITH RUNNING BALANCE | Excel Discussion (Misc queries) | |||
What is the formula for bank account row balance column | Excel Worksheet Functions | |||
I want a running balance like a bank statement | New Users to Excel |