| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to make a cell show average of the last 5 entries in a column?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a cell show average of the last 5 entries in a column?
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 --- "Hal" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make Column Chart use percent and show value | Charts and Charting in Excel | |||
| Cell Entries show as decimal | Excel Worksheet Functions | |||
| Show average value as a horizontal line in a column chart | Charts and Charting in Excel | |||
| make cell entries a negative number | New Users to Excel | |||
| Average of column entries | Excel Discussion (Misc queries) | |||
Linear Mode
