I just started using excel and I have been stuck on a problem all morning.
I am supposed to find the Average of a group of numbers while discarding the smallest Number.
I am supposed to use the Sum,Min and Count function. For the life of me I cannot get the answer.
these are the numbers: 100 95 85 100 95 90 85
The book says to get the average while discarding the lowest number and the correct answer is supposed to be 94.2 but I cannot get it. I used =sum(range)-min(range)/count(range) but it gives me 637.9. Can anyone help me?
Bookmarks