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

[johnny]

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?

 

[KL]

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

 

[Biff]

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]

Thanks guys, helped a lot

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