Averaging the 10 smallest numbers from a group of 20.

[ChiefBull]

I would like to average the 10 smallest numbers from a selection of 20 cells. What function will choose the 10 smallest? I have excel 2003.

Thank you,

ChiefBull

[NBVC]

Try:

=AVERAGE(SMALL(A1:A20,ROW(1:10)))

Adjust range, A1:A20 to suit (this is your entire range)

Formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER. You'll see {} brackets appear around the formula.

[ChiefBull]

Thank you, can I use it as part of a IF statement?

ChiefBull

[NBVC]

Thank you, can I use it as part of a IF statement?

ChiefBull

Yes you can, but you will have to give details of what exactly you need for us to help with the formula.