Help with a calculation

Question

I need a formula to calculate the average of the lowest 8 of 20 numbers.E.g.2, 4, 6, 8, 3, 11, 9, 8, 3, 10,&nbsp;2, 4, 6, 8, 3, 11, 9, 8, 3, 10,&nbsp; Answer is 3&nbsp;

hansvogelaar · Answer

Dave_Moyse&nbsp;
Let's say the numbers are in A2:A21.
&nbsp;
As an ordinary formula:
=AVERAGE(SMALL(A2:A21,{1,2,3,4,5,6,7,8}))
or
=AVERAGEIF(A2:A21,"&lt;="&amp;SMALL(A2:A21,8))
As an array formula confirmed with Ctrl+Shift+Enter:
=AVERAGE(SMALL(A2:A21,ROW(1:8)))

sergeibaklan · Answer

Dave_Moyse&nbsp;
That could be
=AVERAGEIF(A1:A20,"&lt;=" &amp; SMALL(A1:A20,8))
if numbers are in A1:A20

dave_moyse · Answer

HansVogelaar&nbsp;Thanks, all resoled.&nbsp;

dave_moyse · Answer

Thanks, all good.SergeiBaklan&nbsp;

Forum Discussion

Help with a calculation

4 Replies

Resources