how to average and use sum min and count within one cell
It's just the average (sum/count), throwing out the lowest of the four:
=(sum(a1:a4)-min(a1:a4))/(count(a1:a4)-1)
"gwtechie72" wrote:
I am trying to find the average of 4 grades, I have to eliminate the lowest
grade, but I have to use the Sum, Min and Count to get the answer
|