calculating moving average

[Guest]

would like to ba able to calculate the last 3 entries of any given row. how
ever the data(score) may not be in the last three colums. EG. Four columns
A and Three rows 1:3

A B C D (Average)

1- 2 3 4 3

2- 2 2 2 2

3- 3 6 3 3 4

 

[Jerry W. Lewis]

=AVERAGE(IF(ISNUMBER(A11)*(COLUMN(A11)>=LARGE(IF(ISNUMBER(A11),COLUMN(A11)),3)),A11))

Array entered (ctrl-shift-enter)

Jerry

 

[Jason Morin]

One way, array-entered:

=AVERAGE(OFFSET(A1,,MATCH(9.99999999999999E+307,1:1)-1,,-
1+LARGE(IF(1:1<>"",COLUMN(1:1)),3)-MATCH
(9.99999999999999E+307,1:1)))

The above example is for row 1. Modify accordingly.

HTH
Jason
Atlanta, GA