Finding the average by dropping the lowest

jleiler2004 · Nov 19, 2004

I have four tests and I have to find the average by dropping the lowest and
by using sum, min, and count functions.

tjtjjtjt · Nov 19, 2004

Off the top of my head:
=(SUM(I15:I18)-MIN(I15:I18))/(COUNT(I15:I18)-1)

tj