Thread: How do I find the 12 highest numbers in a row of 52 numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default How do I find the 12 highest numbers in a row of 52 numbers
Hi!

Try one of these:

=SUM(LARGE(A1:AZ1,{1,2,3,4,5,6,7,8,9,10,11,12}))

Or, entered as an array using the key combination of CTRL,SHIFT,ENTER:

=SUM(LARGE(A1:AZ1,ROW(INDIRECT("1:12"))))

Biff

"johnny" wrote in message
...
How do I find the 12 highest numbers in a row of 52 numbers, add them
together and enter the total in a particular cell?


Reply With QuoteReply With Quote