Any suggestions?

Hi,

Maybe this

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

Averages the 3 smallest values in A1 - a10.

Mike

"Keith K" wrote:

Any suggestions?

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?

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?

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?