Tranferring totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top