value of last cell in column

[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?

 

[Guest]

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

 

[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)