ExcelBanter - average of several cells excluding the minimum

Try something like this:

For values in A1:A10

If there may be more than one value matching the MINIMUM value and you only
want to exclude one of them:

=(SUM(A1:A10)-MIN(A1:A10))/(COUNT(A1:A10)-1)
(easiest)

or

=AVERAGE(IF((A1:A10+1/ROW(A1:A10))MIN((A1:A10)+1/ROW(A1:A10)),A1:A10))
Note: Commit that array formula by holding down the [Ctrl][Shift] keys and
press [Enter].

Alternatively, if there will only be one instance of the minimum value or
you want to exclude all values that match the minimum:
=AVERAGE(IF(A1:A10MIN(A1:A10),A1:A10))
Note: Commit that array formula by holding down the [Ctrl][Shift] keys and
press [Enter].

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Ashley32" wrote:

how do i take the average of several cells in microsoft excell EXCLUDING the
minmum value? what function do i sue?