D DeWayne Sep 17, 2009 #1 I want to exclude the MAX and MIN values in the range for the AVERAGE function.
T T. Valko Sep 17, 2009 #2 One way: =TRIMMEAN(A1:A10,2/COUNT(A1:A10)) Note that will exclude *one instance each* of the min and max. 10 10 20 30 40 40 The above formula will average 10,20,30,40 = 25
One way: =TRIMMEAN(A1:A10,2/COUNT(A1:A10)) Note that will exclude *one instance each* of the min and max. 10 10 20 30 40 40 The above formula will average 10,20,30,40 = 25
F Fred Smith Sep 17, 2009 #3 Do you want something like this: =(sum(a1:a100)-max(a1:a100)-min(a1:a100))/(count(a1:a100)-2) ? Regards. Fred
Do you want something like this: =(sum(a1:a100)-max(a1:a100)-min(a1:a100))/(count(a1:a100)-2) ? Regards. Fred