 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Running Balance
How do I use the last total of a running balance in another cell? You reference it. If your last total of a running balance is in C5, in the other cell, you reference it as: =C5 Regards, Fred. > How do I use the last total of a running balance in another cell? If the totals are in Column A, and the locations are changing in an on-going basis, you can use this formula in another column: =LOOKUP(99^99,A:A)  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > How do I use the last total of a running balance in another cell? For a running balance or running total such as the following: Column Name: A B C D (Where C = Balance and D = Running Balance) Row 1: x y $50 =$C1 Row 2: y z $30 =$C2 + $D1 Row 3: a b $20 =$C3 + $D2 From here, select drag D3 and pull it down to the bottom. Excel will be smart enough to increment the row numbers. It will keep the column names locked because of the ($). > How do I use the last total of a running balance in another cell? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.