| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel golf scores, how do I add the scores for all par 3's etc | Excel Worksheet Functions | |||
| Summing a column | Excel Discussion (Misc queries) | |||
| summing column c based an column a criteria | Excel Worksheet Functions | |||
| Summing a Column instead of a Column range | Excel Discussion (Misc queries) | |||
| Summing one column based on date in another column | New Users to Excel | |||
Linear Mode
