How do I exclude the HIGH and LOW values in the =AVERAGE function
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
--
Biff
Microsoft Excel MVP
"DeWayne" wrote in message
...
I want to exclude the MAX and MIN values in the range for the AVERAGE
function.
|