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.

"Victor" wrote in message
...
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)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Victor" wrote in message
...
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 ($).

"Victor" wrote:

How do I use the last total of a running balance in another cell?