Average Formula for the smallest x of xx values

[Keith K]

Any suggestions?

 

[Mike H]

Hi,

Maybe this

=AVERAGE(SMALL(A1:A10,{1,2,3}))

Averages the 3 smallest values in A1 - a10.

Mike

 

[T. Valko]

This will average the 3 smallest numbers in the range:

=AVERAGE(SMALL(A1:A10,{1,2,3}))

 

[Shane Devenshire]

Hi,

Try

=AVERAGE(SMALL(A1:A10,ROW(INDIRECT("1:"&B1))))

Where you enter the x in B1.

If you want x and xx to be variables then

=AVERAGE(SMALL(INDIRECT("A1:A"&B1),ROW(INDIRECT("1:"&B2))))

where B1 tells how many row starting in A1 and B2 tell how many items to be
averaged.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[Keith K]

Thanks for both answers. I will look into the indirect one more closely to
see if it fits my needs also.
Keith