how to get more than one highest values

[shaki]

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

 

[Ken Johnson]

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

 

[Ken Johnson]

And...

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

is another.

Ken Johnson

 

[bplumhoff]

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