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)
Posted by at

1 comment:

  1. Unknown21 October 2018 at 23:05

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

    ReplyDelete

Subscribe to: Post Comments (Atom)