Hi

Maybe
=AVERAGE(LARGE(E1:E14,{1;2;3}))

Arvi Laanemets


"Don Guillett" <donaldb@281.com> wrote in message
news:uZEy6S48FHA.2036@TK2MSFTNGP14.phx.gbl...
> does this help
> =SUM(LARGE(E1:E14,{1,2,3}))/3
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Belzbub" <Belzbub@discussions.microsoft.com> wrote in message
> news:761625F9-9AB4-4B29-A37A-1EA9600ED61B@microsoft.com...
> > Hi, im making a worksheet for our shooting results. I need the average
of
> > the
> > top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can
> > anyone help me with this one??
>
>