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