Summing the best 8 scores in a column
 

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?

Summing the best 8 scores in a 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.

"Greener2224" wrote in message
...
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?

Summing the best 8 scores in a column
 

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

"Greener2224" wrote:

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?

Summing the best 8 scores in a column
 

Thanks

"Gaurav" wrote:

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.

"Greener2224" wrote in message
...
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?

Summing the best 8 scores in a column
 

Thanks very neat

"Mike H" wrote:

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

"Greener2224" wrote:

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?