One way

=LOOKUP(2,1/(Sheet2!B1:B65535<""),Sheet2!B1:B65535)


--

Regards,

Peo Sjoblom


"Scott R" wrote in message
...
I have a summary table in sheet 1 that needs the totals from other sheets
in
the workbook. the totals on the other sheets totals are on the last row of
the sheets however these rows constantly change.
Is there a way i can tell exceel to look at column b in sheet 2 and always
look at the last row for the amount?