Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average a list with high and low ignored | Excel Worksheet Functions | |||
Average of a list with high and low ignored | Excel Discussion (Misc queries) | |||
Exclude zero values using average function in a pivot table | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
How to average a column, but exclude zero AND negative values? | Excel Discussion (Misc queries) |