Summing the best 8 scores in a column

  • Thread starter Thread starter Greener2224
  • Start date Start date
G

Greener2224

I have a sheet where I have 149 columns each containing 33 data items. Is
there a way to sum the highest 8 scores in each column?
 
One way...

=SUM(LARGE(A1:A33,1),LARGE(A1:A33,2),LARGE(A1:A33,3),LARGE(A1:A33,4),LARGE(A1:A33,5),LARGE(A1:A33,6),LARGE(A1:A33,7),LARGE(A1:A33,8))

Then just drag it to the right.

Hope that helps.
 
Hi,

I'm not sure about doing it in a single formula but you could sum each of
the columns with these formula and sum those

=SUM(LARGE(A1:A33,{1,2,3,4,5,6,7,8}))
=SUM(LARGE(B1:B33,{1,2,3,4,5,6,7,8}))
etc

Mike
 
Thanks

Gaurav said:
One way...

=SUM(LARGE(A1:A33,1),LARGE(A1:A33,2),LARGE(A1:A33,3),LARGE(A1:A33,4),LARGE(A1:A33,5),LARGE(A1:A33,6),LARGE(A1:A33,7),LARGE(A1:A33,8))

Then just drag it to the right.

Hope that helps.
Click to expand...
 
Thanks very neat

Mike H said:
Hi,

I'm not sure about doing it in a single formula but you could sum each of
the columns with these formula and sum those

=SUM(LARGE(A1:A33,{1,2,3,4,5,6,7,8}))
=SUM(LARGE(B1:B33,{1,2,3,4,5,6,7,8}))
etc

Mike
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sum the 3 best scores for every country in an contest? 5
Sports summary sheet - think I put this in wrong place originally 1
Sum Value of rows based on two common fields 5
Need help on scoring 1
Need help with a function for a golf match spreadsheet 1
Lookup multiple cell values and place contents in a single cell 3
how do I use array references in VLOOKUP()? 2
Summing numbers dropping lowest and highest 2

Back
Top