ExcelBanter - Total the highest 5 of 8 amounts.

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Total the highest 5 of 8 amounts. (https://www.excelbanter.com/new-users-excel/140505-total-highest-5-8-amounts.html)

TheDrip

Total the highest 5 of 8 amounts.

I need a formula to total the highest 5 out of 8 values. please help me.

Bob Phillips

Total the highest 5 of 8 amounts.

=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)

"TheDrip" wrote in message
...
I need a formula to total the highest 5 out of 8 values. please help me.

TheDrip

Total the highest 5 of 8 amounts.

Thank You Bob, Very much.

"Bob Phillips" wrote:

=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)

"TheDrip" wrote in message
...
I need a formula to total the highest 5 out of 8 values. please help me.

All times are GMT +1. The time now is 06:33 PM.