| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average
What formula would I use the get the average of each set subtracting the MIN
and MAX out of each? Judge 1 10 10 Judge 2 8 8 Judge 3 9 9 Judge 4 9 9 Judge 5 9 9 Average Total |
|
#2
|
|||
|
|||
|
One way
=TRIMMEAN(A1:A10,0.2) or written =TRIMMEAN(A1:A10,2/COUNT(A1:A10)) Regards, Peo Sjoblom "Runfst2win" wrote: What formula would I use the get the average of each set subtracting the MIN and MAX out of each? Judge 1 10 10 Judge 2 8 8 Judge 3 9 9 Judge 4 9 9 Judge 5 9 9 Average Total |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
| Plotting moving average line on a chart | Charts and Charting in Excel | |||
| Complex Average | Excel Worksheet Functions | |||
| how do I get AVERAGE to ingore a zero value cell | Excel Worksheet Functions | |||
| average, array and offsets | Excel Worksheet Functions | |||
Linear Mode
