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.