View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Roy
 
Posts: n/a
Default How can i get the 3 highest in a range

YES! in stead of an formula that is huge, I now have this little formula.
BIG THANKS

/Roy

Biff skrev:

Hi!

Try this:

=SUM(LARGE(A1:A10,{1,2,3}))

Biff

"Roy" wrote in message
...
Hi,
I have a range of 10 numbers.
How can I get the sum of the 3 highest numbers in a range?