| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When Averaging a column, exclude value based on another cell value | Excel Worksheet Functions | |||
| Averaging Cells Based On Conditions in Neighboring Cells | Excel Discussion (Misc queries) | |||
| Averaging a column with 0's | Excel Worksheet Functions | |||
| Automating averaging a column over time periods. | Excel Discussion (Misc queries) | |||
| Averaging Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
