Thankyou, works well appreciate the help

"Jacob Skaria" wrote:

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"
Try the below with numbers in A1:A20

=AVERAGE(SMALL(A1:A20,ROW(A1:A10)))

If this post helps click Yes
---------------
Jacob Skaria


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