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


"johnny" <(E-Mail Removed)> wrote in message
news:8F37BB3B-5B9F-4D7B-9511-(E-Mail Removed)...
> 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!

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" <(E-Mail Removed)> wrote in message
news:8F37BB3B-5B9F-4D7B-9511-(E-Mail Removed)...
> 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?

Thanks guys, helped a lot

"Biff" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:8F37BB3B-5B9F-4D7B-9511-(E-Mail Removed)...
> > 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?
>
>
>