value of last cell in column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jacob - 31 Jan 2007 15:37 GMT

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?

Reply to this Message

E-Coder - 31 Jan 2007 16:03 GMT

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

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

Reply to this Message

Bob Phillips - 31 Jan 2007 16:20 GMT

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

etc.

Signature

---
HTH

Bob

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

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

Reply to this Message

Rate this thread: