Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding the average by dropping the lowest
I have four tests and I have to find the average by dropping the lowest and
by using sum, min, and count functions. |
#2
|
|||
|
|||
Off the top of my head:
=(SUM(I15:I18)-MIN(I15:I18))/(COUNT(I15:I18)-1) tj "jleiler2004" wrote: I have four tests and I have to find the average by dropping the lowest and by using sum, min, and count functions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average, array and offsets | Excel Worksheet Functions | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions | |||
Average Column, but Skip Null and 0? | Excel Worksheet Functions | |||
Average determination | Excel Worksheet Functions | |||
Average Formula | Excel Worksheet Functions |