Summing the best 8 scores in a column

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?
 
G

Gaurav

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.
 
M

Mike H

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
 
G

Greener2224

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...
 
G

Greener2224

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
Auto select highest 25 scores. 14
Referencing text of a cell next to the greatest value in column 1
Summing numbers dropping lowest and highest 2
Easy question: Sort ascending in a row? 3
Find the last 4 cell entries in a row 2
Golf Handicap 3
Best 25 scores..help please 19

Top