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