I need a formula to total the highest 5 out of 8 values. please help me.
=SUM(LARGE(G1:G8,{1,2,3,4,5}))

Signature
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
>I need a formula to total the highest 5 out of 8 values. please help me.
TheDrip - 26 Apr 2007 12:32 GMT
Thank You Bob, Very much.
> =SUM(LARGE(G1:G8,{1,2,3,4,5}))
>
> >I need a formula to total the highest 5 out of 8 values. please help me.