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?
|