Morning guys,
I would appreciate any help with this.
In the attached spreadsheet in column T, I would like it to add up the highest 8 values in the columns B to Q, only.
Thanks for any help you can give.
Morning guys,
I would appreciate any help with this.
In the attached spreadsheet in column T, I would like it to add up the highest 8 values in the columns B to Q, only.
Thanks for any help you can give.
Last edited by Cmorgan; 01-21-2013 at 07:45 AM.
Perhapsentered as an array formula with Ctrl+Shift+EnterPlease Login or Register to view this content.
Hi Cmorgan
If you want any other combo, just edit the array.
Formula:Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Hi,
try copying this formula to T2I took the idea from here:Please Login or Register to view this content.
http://chandoo.org/wp/2010/06/04/ave...-top-5-values/
try the attached macro by clicking the button
Many thanks for this, I am using:
=SUM(LARGE(B2:Q2,{1,2,3,4,5,6,7,8}))
I now need to add an additional column that:
B2 + C2 + (the highest 6 scores from D2:Q2)
I've tried:
=SUM(B2+C2+(LARGE(D2:Q2,{1,2,3,4,5,6})))
But it doesn't seem to work, any ideas will be greatfully appreciated.
Try in this way.
=SUM(LARGE(D2:Q2,{1,2,3,4,5,6}))+B2+C2
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you for all the help, from all you guys - it's much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks