Average Formula for the smallest x of xx values
 

Any suggestions?

Average Formula for the smallest x of xx values
 

Hi,

Maybe this

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

Averages the 3 smallest values in A1 - a10.

Mike

"Keith K" wrote:

Any suggestions?

Average Formula for the smallest x of xx values
 

This will average the 3 smallest numbers in the range:

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

--
Biff
Microsoft Excel MVP


"Keith K" <Keith wrote in message
...
Any suggestions?

Average Formula for the smallest x of xx values
 

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" wrote:

Any suggestions?

Average Formula for the smallest x of xx values
 

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



"Shane Devenshire" wrote:

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" wrote:

Any suggestions?