| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average of Last 10
Try this array formula (commit with Ctrl+shift+Enter):
=IF(COUNT(A6:W6),AVERAGE(INDEX(A6:W6,LARGE(IF(A6:W 6<"",COLUMN(A6:W6)),MIN(COUNT(A6:W6),10))):W6),"N O DATA") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "GaryC" wrote: What I am trying to do is track a 10 week rolling average, where scores are entered weekly in row A6 thru W6. The formula needs to count back starting with W6 until it counts 10 scores then average them. Some cells may be blank. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for determing average based on weighting | Excel Worksheet Functions | |||
| plotted Average | Charts and Charting in Excel | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Threaded Mode
