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