Picking out the highest 4 of a selection on a row

I have a spreadsheet set up with rows of values, I want to be able to get excel to pick out the highest four values from a selection of columns within the row and give them a sum total.

How??

Please help!


Amie

Use the below assuming your data is in the range A1:A100

Please Login or Register  to view this content.

Show your appreciation - Click on the star icon if this post has been helpful

That covers a range down a column, I need it across a row. Is that not possible?

Try this ..the row range is A:P

Please Login or Register  to view this content.

Show your appreciation - Click on the star icon if this post has been helpful

Oh, and I forgot to add that the colunms I want it to pick from are not adjacent to each other.

I am probably wanting to do something thats not possible!

Thanks again

How about this...?
Columns A,B,Q,AA,AD hold the data

Please Login or Register  to view this content.

Show your appreciation - Click on the star icon if this post has been helpful

not sure I have explained it very well, I want it to sum the top four values from row 5 columns c,d,e,f,h,l,p,q
Then in a different cell I want to repeat the formula for columns g,i,j,k,m,n,o,r

Does that make it clearer?
Thank you

Replace columns in Post#6 with desired ones to achieve the results

Show your appreciation - Click on the star icon if this post has been helpful

ah wrote my reply at the same time, will give that a go

Fantastic - works a dream!

Thank you sooooooo much :D

Amie

Glad it did ..please mark the thraed as 'Solved'. Enjoy the forum!

How do I do that??? :s

New to this forum! lol

Welcome again!

here's how..
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

http://www.excelforum.com/forum-rule...rum-rules.html

Cheers, and done.

Back to the work book now