Running Balance

F

Fred Smith

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.
 
R

Ragdyer

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)
 
B

Brian

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 ($).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top