Thread: Summing the best 8 scores in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_3_] Gaurav[_3_] is offline
external usenet poster
  
Posts: 127
Default 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?


Reply With QuoteReply With Quote