View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Smith Bob Smith is offline
external usenet poster
 
Posts: 28
Default Averaging last 5 cells in a column

Hi folks,

In my workbook, I have a bunch of worsheets, where I'm average all numbers
in one column. I'd like to add one more stat, to where I'd like to average
the last 5 #'s in a column. Only thing is that no column ends on the same
row, so I can't specifiy specific cells..

Need some help to develop an average formula to pick the last five entries
in a column.

TIA.

Bob