Finding more than one number

[alexriverajr]

I'm trying to create some excel formatting to execute the the following:

-Find the highest 8 numbers out of 10 numbers.
-Find the sum of those eight value.

Is this possible in excel? If so, can someone assist me with it.

Alex

[Paul]

Hi Alex, and welcome to the forum.

You should be able to use the array formula:

=SUM(IF(A1:A20>=LARGE(A1:A20,8),A1:A20))

After typing/editing this formula, you must press CTRL+SHIFT+ENTER, not just ENTER. When done properly Excel will automatically insert braces around your formula.

One note, though: If there are multiple instances of the 8th largest value, it will include all of them in the sum.

Hope that helps!

[DonkeyOte]

Another alternative re: Summation

=SUM(LARGE(A1:A10,{1,2,3,4,5,6,7,8}))

[Paul]

Ahh, that seems to work better than mine. I never can remember where I can use those {arrays}.

Gracias.

[alexriverajr]

Thanks all. Your help is greatly appreciated.