How do I exclude the HIGH and LOW values in the =AVERAGE function
I want to exclude the MAX and MIN values in the range for the AVERAGE function.
|
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. |
How do I exclude the HIGH and LOW values in the =AVERAGE function
Do you want something like this:
=(sum(a1:a100)-max(a1:a100)-min(a1:a100))/(count(a1:a100)-2) ? Regards. Fred "DeWayne" wrote in message ... I want to exclude the MAX and MIN values in the range for the AVERAGE function. |
All times are GMT +1. The time now is 12:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com