Fireant Posted November 17, 2008 Share Posted November 17, 2008 (edited) 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 Link to comment Share on other sites More sharing options...
Ms. Kitty Posted November 17, 2008 Share Posted November 17, 2008 (edited) 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 Link to comment Share on other sites More sharing options...
Fireant Posted November 17, 2008 Author Share Posted November 17, 2008 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 More sharing options...
moverfive Posted November 17, 2008 Share Posted November 17, 2008 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 More sharing options...
Fireant Posted November 17, 2008 Author Share Posted November 17, 2008 Thank you MS. Kitty and Moverfive. Your help will make my end of the year awards caculating a lot quicker. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now