Excel formula for number selection

[Ernest35]

Hi

Can I write a formula to pick 2 or 3 or 4 of the smallest numbers out of a range of 10

Thank you

Ernest35

[VBA Noob]

Hi,

This returns the 2nd smallest value

=SMALL(A1:A7,2)

this returns the sum of the 3 smallest values

=SUM(SMALL(A1:A7,{2,3,4}))

VBA Noob

[Ernest35]

Hi again, so soon

Thank you for the quick reply.

Unfortuantly, I'm am posting with a computer that does not have Excel, so I can't confirm it works.

However, I'm curious about the (A1:A7), if the range of numbers is 10?

Ernest35

[VBA Noob]

As your post was lacking info I took a random range e.g A1:A7

If you have a range of 10 cells then use that with the large function.

Use excel's help to learn more on the large function

VBA Noob