It compares each value to the minimum value in the range.
Values not greater than the minimum are ignored.
I meant to mention that the formula will return #DIV/0 if all the numbers in
the range are the same.

This article will explain it. Also, try a web search for Array Formulas in
Excel.
http://office.microsoft.com/en-us/as...872901033.aspx
--
tj


"ynissel" wrote:

Wow - I cant believe that worked - but I dont understand the formula. CAn
you try to explain ?
Thanks,
Yosef

"tjtjjtjt" wrote:

This is working after a couple of simple tests:
=AVERAGE(IF(D1:D6MIN(D1:D6),D1:D6))
Use Ctrl+Shift+Enter to input this formula. It will return #VALUE if you
only press enter.
--
tj


"ynissel" wrote:

Is there a function to average a series of numbers but dropping the lowest ?
Thanks,
Yosef