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. |
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. |
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. |
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. |
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. |
Adding more than one maximum
Welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "stevengepp" wrote in message ... Thanks. This worked well. |
All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com