Thread
:
I have 12 scores over 12 weeks . I want to average the highest 5
View Single Post
#
1
Bob Phillips
Posts: n/a
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" wrote in message
...
Reply With Quote