K
Keith K
Any suggestions?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi,
Maybe this
=AVERAGE(SMALL(A1:A10,{1,2,3}))
Averages the 3 smallest values in A1 - a10.
Mike
Maybe this
=AVERAGE(SMALL(A1:A10,{1,2,3}))
Averages the 3 smallest values in A1 - a10.
Mike
T
T. Valko
This will average the 3 smallest numbers in the range:
=AVERAGE(SMALL(A1:A10,{1,2,3}))
=AVERAGE(SMALL(A1:A10,{1,2,3}))
S
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
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
K
Keith K
Thanks for both answers. I will look into the indirect one more closely to
see if it fits my needs also.
Keith
see if it fits my needs also.
Keith