For example, we want to add the best two values

A B C D E
1 7 9 4 2 ---> it will add 7 and 9


Cheers.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

shaki wrote:
> For example, we want to add the best two values
>
> A B C D E
> 1 7 9 4 2 ---> it will add 7 and 9
>
>
> Cheers.
>
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com

=LARGE(A1:E1,1) + LARGE(A1:E1,2)

is one way

Ken Johnson

And...

=SUM(LARGE(A1:E1,{1,2}))

is another.

Ken Johnson

Hello,

=LARGE(A1:E1,1)+LARGE(A1:E1,2)

or

=SUMPRODUCT(LARGE(A1:E1,{1,2}))

or

=SUMPRODUCT(LARGE(A1:E1,ROW(INDIRECT("1:"&B2))))

[enter 2 into cell B2 - this formula might be useful if you ever want
to add up more than the two highest values - but keep in mind that the
result of 9 7 9 6 would be 18, not 16!]

HTH,
Bernd