Sum 3 highest numbers
Hi!
Your subject line was Sum 3 highest numbers but your question was to average
only the 3 highest. So, here's both:
=AVERAGE(LARGE(A1:A4,{1,2,3}))
=SUM(LARGE(A1:A4,{1,2,3}))
Biff
"Molly" wrote in message
...
Dear experts,
If I have a selection of four numbers and want to average only the 3
highest
what would be the best way to do this?
Molly
|