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?
|