I have 12 scores over 12 weeks . I want to average the highest 5

[Directioneng]

[Bob Phillips]

Here is an example

=SUMPRODUCT(LARGE(A1:A12,{1,2,3,4,5}))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Directioneng" <Directioneng@discussions.microsoft.com> wrote in message
news:19F577FA-9772-44D1-B3CA-58E103797F5E@microsoft.com...
>