Another one...

=LOOKUP(1E100,B:B)

--
Biff
Microsoft Excel MVP


"Jen S" wrote in message
...
I am looking for a formula that would have the last number listed in a
column
listed in the total or summary row of the spreadsheet.
Column A lists the month of the year Column B lists # of files
pending
Jan
10
Feb
12
Mar
7


Summary -- I want this to show the last number in Column B -- in this
example 7. Thank you.