Adding

[anb001]

I need a formula which can add the three highest values from a range of
four cells. If you e.g. have the values 2 - 1 - 3 - 4 in cells A1-A4,
it should add values 2 - 3 - 4 in cell A5. If the values are 2 - 2 - 3
- 2, it should just add 3 - 2 - 2.

It's probably simple, but I'd appreciate any help you can give.
Thanks.

 

[Frank Kabel]

Hi
try
=SUM(LARGE(A1:A4,{1,2,3}))

 

[anb001]

Super.
Thanks

 

[Stephen Bye]

How about:
=SUM(A1:A4)-MIN(A1:A4)