Finding the average by dropping the lowest

Guest · 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.

Guest · Nov 19, 2004

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

tj

Trying to find additional ranges outside of min, max, and average	2	Aug 17, 2013
Average Grades and drop the lowest score	5	Oct 15, 2004
nested "IF" function in Excel 2007	2	Nov 3, 2008
Calculating average discarding lowest value	3	Jul 29, 2006
Average Function	6	Nov 20, 2003
Need help with formula and functions =AVERAGE	5	Oct 3, 2003
how to average and use sum min and count within one cell	4	Oct 18, 2005
Trying to subtract the two lowest values from a row of numbers	4	Nov 17, 2008

Ask a Question