Jump to content
Brian Enos's Forums... Maku mozo!

Excel help


Fireant

Recommended Posts

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 by Fireant
Link to comment
Share on other sites

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 by Ms. Kitty
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...