On Mar 22, 8:11*pm, "T. Valko" wrote:
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.- Hide quoted text -

- Show quoted text -

=INDIRECT("C"&MAX(IF($C$35:$C$52<0,ROW($C$35:$C$5 2))))

This is an Array formula

Cntr-Alt-Enter to implement