V
val
how do i drop the lowest number and average all of them except the lowest
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mzehr
Hi Val
Try the following entered as an array (Shift-Ctrl-Enter)
=AVERAGE(IF(A1:A5<>MIN(A1:A5),A1:A5))
Try the following entered as an array (Shift-Ctrl-Enter)
=AVERAGE(IF(A1:A5<>MIN(A1:A5),A1:A5))
K
Ken Wright
=(SUM(A1:A20)-MIN(A1:A20))/(COUNT(A1:A20)-1)
K
Ken Wright
Need to be careful there - what happens with 4 3 2 1 1
It will lose two of the values and not just *the* lowest number as there is more
than one. Now this may well be what the OP wants but the question needs to be
clarified really.
It will lose two of the values and not just *the* lowest number as there is more
than one. Now this may well be what the OP wants but the question needs to be
clarified really.
M
mzehr
Val,
FYI I should explain the difference between Ken's response and mine, so that
you are aware. Should you use the array formula that I gave you, it will
automatically eliminate all of the minimums. For example if you have
1
1
3
4
5
The array formula will give you an average of 4, where as the formula Ken
gave would give an average of 3.25
The Array formula considers the event of a tie, and throws out both 1's
leaving you with 3, 4 and 5 and averages those.
Both are valid, just depends on what you're looking for
FYI I should explain the difference between Ken's response and mine, so that
you are aware. Should you use the array formula that I gave you, it will
automatically eliminate all of the minimums. For example if you have
1
1
3
4
5
The array formula will give you an average of 4, where as the formula Ken
gave would give an average of 3.25
The Array formula considers the event of a tie, and throws out both 1's
leaving you with 3, 4 and 5 and averages those.
Both are valid, just depends on what you're looking for
M
mzehr
I agree Ken. I just posted the same message to Val so she would be awareof
that.
that.