Tranferring totals

[MCorn]

Hi
I have a check book spreadsheet that when you make a deposit of a payment the total shows in the following cell. My question is this: Is there a way to take the total that moves from different cells and show in a fixed cell? For example

Cash In: CashOut: Balance: Total
100.00 100.00 150.0
50.00 50.0
100.00 150.0

Whatever changes that were made in the balane column I would like to see it in the Fixed total Cell. Any help would be appreciated! MCorn

 

[Frank Kabel]

Hi
try the following formula to get the value of the last row in column C
(your total):
=OFFSET($C$1,COUNTA($C:$C)-1,0)
works only if there are no blanks in column C in between

Frank