"Shane Devenshire" wrote:
In 2007 you can do this without an array formula:
=AVERAGEIF(A1:A20,"<"&SMALL(A1:A20,11))

I don't believe that works when the 11th smallest is equal to the 10th
smallest. Test with the following array:

10,20,...,90,100,100,120,...,200

The average of the first 10 should always be 55.


PS: In both Excel 2003 and 2007, the following non-array formula is
equivalent to that AVERAGEIF for 10 numbers:

=sumproduct(--(A1:A20<small(A1:A20,11)),A1:A20) / 10


----- original message -----

"Shane Devenshire" wrote in
message ...
Hi,

In 2007 you can do this without an array formula:
=AVERAGEIF(A1:A20,"<"&SMALL(A1:A20,11))

In 2003 use the array:
=AVERAGE(SMALL(A1:A20,ROW(1:10)))

array - means you enter this by pressing Shift+Ctrl+Enter

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"picks72" wrote:

I have 20 values in a row or column and what to average the lowest 10
values
of these 20. Is there a formula I can use?