Excel help

[Fireant]

Can I get Excel to give me the sum of the highest 6 values from a row of up to 12 values? If so, how?

For example

Row 1 100 90.5 93.8 100 99.08 68.22 99.05 100 100 100 best six would be 599.08

Edited November 17, 2008 by Fireant

[Ms. Kitty]

Can I get Excel to give me the sum of the highest 6 values from a row of up to 12 values? If so, how?

For example

Row 1 100 90.5 93.8 100 99.08 68.22 99.05 100 100 100 best six would be 599.08

yes. Can you pm?

Edited November 17, 2008 by Ms. Kitty

[Fireant]

Can I get Excel to give me the sum of the highest 6 values from a row of up to 12 values? If so, how?

For example

Row 1 100 90.5 93.8 100 99.08 68.22 99.05 100 100 100 best six would be 599.08

Are you wanting to Average or the Sum of the best six?

The sum of the best six.

[moverfive]

Can I get Excel to give me the sum of the highest 6 values from a row of up to 12 values? If so, how?

For example

Row 1 100 90.5 93.8 100 99.08 68.22 99.05 100 100 100 best six would be 599.08

Are you wanting to Average or the Sum of the best six?

The sum of the best six.

the simplest and quickest way would be to rank each entry and then only add the top 6.

In essence, the first line will be your actual data, the 2nd line would be the RANK line, and then the 3rd line would be the sum of those items that rank 6 or less.

Make sense?

[Fireant]

Thank you MS. Kitty and Moverfive. Your help will make my end of the year awards caculating a lot quicker.