T thomas wald Jul 12, 2005 #1 I need a formula that will figure the average of any range of numbers dropping the lowest number Thomas Goldstein
I need a formula that will figure the average of any range of numbers dropping the lowest number Thomas Goldstein
J JE McGimpsey Jul 12, 2005 #2 One way: =(SUM(rng)-MIN(rng))/(COUNT(rng)-1) This assumes that you mean to drop only one value if there are multiple instances of the "lowest number".
One way: =(SUM(rng)-MIN(rng))/(COUNT(rng)-1) This assumes that you mean to drop only one value if there are multiple instances of the "lowest number".
D Don Guillett Jul 12, 2005 #3 Or an array formula to exclude all instances of the minimum value =AVERAGE(IF(H1:H14<>MIN(H1:H14),H1:H14)) to be entered with ctrl+shift+enter
Or an array formula to exclude all instances of the minimum value =AVERAGE(IF(H1:H14<>MIN(H1:H14),H1:H14)) to be entered with ctrl+shift+enter
