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
 

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

Similar Threads

Transferring Totals (MCorn) 3
Daily Average 2
Adding Multiple Totals in Excel 3
Formula Help PLEASE !!!! 4
Total column changes colors when total equals sum of other columns 1
Ref in two worksheets 1
Multi-demensional frequency distribution 4
Referrence a total in a cell on another worksheet 4

Back
Top