View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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