V
Victor
How do I use the last total of a running balance in another cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
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)
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 ($).
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 ($).