how do i average the 2 smallest number in a range of six numbers

[Guest]

I tried (small(a1:a6,1)+small(a1:a6,2)/2, but got an incorrect number.
Is there problem with syntax, or perhaps another to accomplish what I am
trying to achieve.

Zetstrat

 

[Trevor Shuttleworth]

Try:

(small(a1:a6,1)+small(a1:a6,2))/2
or
small(a1:a6,1)/2+small(a1:a6,2)/2

Regards

Trevor

 

[Guest]

Hi
the following should do
=SUM(SMALL(A1:A6,{1,2}))/2

 

[Guest]

This should do it:
=((SMALL(A1:A6,1))+(SMALL(A1:A6,2)))/2

Your formula calculates out of order. Excel always divides before it adds in
a formula, unless you group parts of the equation together with parentheses.

tj

 

[Guest]

I tried (small(a1:a6,1)+small(a1:a6,2)/2, but got an incorrect number.
Is there problem with syntax, or perhaps another to accomplish what I am
trying to achieve.

Zetstrat

Thanks to everyone for their help

 

[Jerry W. Lewis]

Why not simplify to
=AVERAGE(SMALL(A1:A6,{1,2}))

Jerry

 

[Guest]

You are missing a few parentheses, but Frank and Jerry both provided more
concise formulas anyway.

tj