Search This Blog

Friday 17 August 2012

FIND AVERAGE OF VALUES EXCLUDING MAX AND MIN VALUE


Formula in A13:
=(SUM(A1:A12)-MIN(A1:A12)-MAX(A1:A12))/(COUNT(A1:A12)-2)

1 comment:

  1. Hi,
    This is also working for me (Adjust the range accordingly):-
    =AVERAGE(A65:F65,-MAX(A65:F65),-MIN(A65:F65))*2

    ReplyDelete