Last number in a column shows in the total/summay line cell

J

Jen S

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.
 
F

FSt1

hi
in a cell of your choosing, enter..
=OFFSET(B1,COUNTIF(B1:B100,">0")-1,0)

regards
FSt1
 
Z

Ziggy

Another one...

=LOOKUP(1E100,B:B)

--
Biff
Microsoft Excel MVP







- Show quoted text -
Click to expand...

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

This is an Array formula

Cntr-Alt-Enter to implement
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup doesn't work: results are wrong 2
Formula: Counting Cells on Different Worksheets 3
Calculate total by row number 4
Unhide column difficulty 3
Formula to choose from the last column of a given row 2
Counting multiple occcurrences between date range 3
Rolling 12 month 9
How to paste the same cell one tab over 1

Top