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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I have 12 scores over 12 weeks . I want to average the highest 5 (https://www.excelbanter.com/excel-worksheet-functions/41185-i-have-12-scores-over-12-weeks-i-want-average-highest-5-a.html)

Directioneng

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

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" wrote in message
...

All times are GMT +1. The time now is 02:34 PM.