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