Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding more than one maximum
Is there a way of taking a list of five numbers and adding together only the
highest 3 (ignoring or dropping the two lowest marks)? E.g. if the numbers were 2,5,7,4,5, the numbers 5,7,5 would be added, 2 and 4 being ignored. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding more than one maximum
One way:
In say, B1: =SUMPRODUCT(LARGE(A1:A5,ROW(1:3))) where source data is in A1:A5 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "stevengepp" wrote: Is there a way of taking a list of five numbers and adding together only the highest 3 (ignoring or dropping the two lowest marks)? E.g. if the numbers were 2,5,7,4,5, the numbers 5,7,5 would be added, 2 and 4 being ignored. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding more than one maximum
=SUM(LARGE(A1:A5,{1,2,3}))
"stevengepp" wrote: Is there a way of taking a list of five numbers and adding together only the highest 3 (ignoring or dropping the two lowest marks)? E.g. if the numbers were 2,5,7,4,5, the numbers 5,7,5 would be added, 2 and 4 being ignored. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding more than one maximum
Thanks a lot; this worked really well across several multi-linked spreadsheets.
"Teethless mama" wrote: =SUM(LARGE(A1:A5,{1,2,3})) "stevengepp" wrote: Is there a way of taking a list of five numbers and adding together only the highest 3 (ignoring or dropping the two lowest marks)? E.g. if the numbers were 2,5,7,4,5, the numbers 5,7,5 would be added, 2 and 4 being ignored. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding more than one maximum
Thanks. This worked well.
"Max" wrote: One way: In say, B1: =SUMPRODUCT(LARGE(A1:A5,ROW(1:3))) where source data is in A1:A5 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "stevengepp" wrote: Is there a way of taking a list of five numbers and adding together only the highest 3 (ignoring or dropping the two lowest marks)? E.g. if the numbers were 2,5,7,4,5, the numbers 5,7,5 would be added, 2 and 4 being ignored. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding more than one maximum
Welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "stevengepp" wrote in message ... Thanks. This worked well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
maximum | Excel Worksheet Functions | |||
Maximum | Excel Worksheet Functions | |||
Maximum If Help | Excel Worksheet Functions | |||
MAXIMUM VALUE | Excel Worksheet Functions | |||
Specify Maximum Value | Excel Discussion (Misc queries) |