| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ignore MAX and MIN values in a set to calculate average
I have a set of numbers, say in range A1:A10. I've determined that
the maximum and minimum values in this set are outliers and so want to ignore them when calculating the average. I know I can ignore either the max OR the min by using one of these array formulas: =AVERAGE(IF(A1:A10<MAX(A1:A10),A1:A10)) or =AVERAGE(IF(A1:A10MIN(A1:A10),A1:A10)) How could I combine exclusion of both MAX and MIN? Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate average value in a row ignoring values below "x" | Excel Discussion (Misc queries) | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| Calculate average and not include zero values | Excel Discussion (Misc queries) | |||
| Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
| calculate average in percentage coloumn with #DIV/! (ignore error | Excel Discussion (Misc queries) | |||
![Dave F[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
