ExcelBanter - Finding the average by dropping the lowest

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Finding the average by dropping the lowest (https://www.excelbanter.com/excel-worksheet-functions/6713-finding-average-dropping-lowest.html)

jleiler2004

Finding the average by dropping the lowest

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

tjtjjtjt

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.

All times are GMT +1. The time now is 02:09 AM.