How do I find the 12 highest numbers in a row of 52 numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi johnny,

Something like this:

longer, but non-volatile
=SUMPRODUCT(LARGE(A1:AZ1,{1,2,3,4,5,6,7,8,9,10,11,12}))

shorter, but volatile
=SUMPRODUCT(LARGE(A1:AZ1,ROW(INDIRECT("1:12"))))

or if the numbers can't be repeated:
=SUMIF(A1:AZ1,">="&LARGE(A1:AZ1,12))

Regards,
KL
 
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
 
Thanks guys, helped a lot

Biff said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding location (or start cell) of highest consecutive values 3
Counting Ages 2
Search row of numbers, find highest value. 2
Find the last number in a row 6
The best of 5 cells 3
average of highest 48 of 52 radom numbers with duplicate low #'s 7
highlight the highest cell in a column 1
returning a text value using a formula 1

Back
Top