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" 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?