How to make a cell show average of the last 5 entries in a column?

  • Thread starter Thread starter Hal
  • Start date Start date
H

Hal

I need to make a fixed cell display the average of the last 5 entires in a
column that will periodically have another entry added to it and may at some
point contain 50 or so entries.
 
One way
Assuming continuous numeric data running in A1 down
In B1: =AVERAGE(OFFSET(INDIRECT("A"&COUNT(A:A)),,,-5))
will return the average of the last* 5 numbers in col A
*bottommost
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

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

Averaging last 5 cells in a column 4
average of 5 21
display last entry into a cell automatically 2
Averaging a column that contains text 4
First, Last occurance of date in column 5
Remove punctuation mark, Split cells & average accross column 4
formula for displaying only the last entry of a group of cells 2
Help with Formula in Excel 2003 1

Back
Top