how to get more than one highest values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shaki - 10 Nov 2006 10:23 GMT

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

Reply to this Message

Ken Johnson - 10 Nov 2006 10:47 GMT

> For example, we want to add the best two values
>
[quoted text clipped - 5 lines]
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com

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

is one way

Ken Johnson

Reply to this Message

Ken Johnson - 10 Nov 2006 10:50 GMT

And...

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

is another.

Ken Johnson

Reply to this Message

bplumhoff@gmail.com - 10 Nov 2006 10:52 GMT

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

Reply to this Message