Average Formula for the smallest x of xx values

M

Mike H

Hi,

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}))
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF "value if false" not working 2
SMALL function to find X smallest number greater than Y 6
Goal Seeking via Excel 0
Help with Average formula 4
VBA - exporting serial letters to single documents 0
Trying to find additional ranges outside of min, max, and average 2
Returning 2nd smallest value in a range 9
display Column Header based on cell value in a range 2

Top