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.

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.

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

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.

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.

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"stevengepp" <(E-Mail Removed)> wrote in message
news:3E69283B-09B4-4159-B605-(E-Mail Removed)...
> Thanks. This worked well.