value of last cell in column

J

Jacob

I have a excell file with ten sheets, each from a diffrent bank account with
a running total, I want to have a sheet where I have the last line total of
each bank so I can see in a glance the current balance of all accounts and
total it. How can I tell excel to search for the last line value?
 
E

E-Coder

If you define a name to the range (ie. on Sheet 1 the last line or line total
is named "Total1"), then on your result sheet to see that value, you only
need to use the following formula:

=(Total1)

As you add values, insert and delete cells, the name will stay with that
cell and continue to show that value.

HTH

Eric
 
B

Bob Phillips

=LOOKUP(2,1/(Sheet2!A:A<>""),Sheet2!A:A)

etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top