Hi

If it is a numeric you are looking for, then
=LOOKUP(99^99,A1:A50)
Change range to suit
--
Regards
Roger Govier

"dsharris59" wrote in message
...
I have a excel spread sheet with a long check register column that changes
the total as I add entries. this column is about 50 rows long. I would
like
to have the last cell in column report the last totaled sum. I need it to
change as I add more entries. I will use this cell to report a sum to a
second work sheet.