LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default A running-balance column in a bank-tracking table

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a running total (balance) in a pivot table? Jackie @ TRL Excel Worksheet Functions 1 May 17th 06 03:30 AM
TABLE W/RUNNING BALANCE Donna Cas Excel Discussion (Misc queries) 1 August 30th 05 10:46 PM
TABLE WITH RUNNING BALANCE Donna Cas Excel Discussion (Misc queries) 2 August 30th 05 09:49 PM
What is the formula for bank account row balance column Hazeldean Excel Worksheet Functions 2 May 17th 05 04:34 AM
I want a running balance like a bank statement Roger Campbell New Users to Excel 4 January 25th 05 09:15 AM


All times are GMT +1. The time now is 08:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"