|
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.
|