calculating moving average

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:D 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

=AVERAGE(IF(ISNUMBER(A1:D1)*(COLUMN(A1:D1)>=LARGE(IF(ISNUMBER(A1:D1),COLUMN(A1:D1)),3)),A1:D1))

Array entered (ctrl-shift-enter)

Jerry

odey1234 wrote:

> 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:D 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
>
>

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

>-----Original Message-----
>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:D 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
>
>.
>