View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jen S[_2_] Jen S[_2_] is offline
external usenet poster
 
Posts: 1
Default Last number in a column shows in the total/summay line cell

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.