how to average and use sum min and count within one cell
 

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

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

how to average and use sum min and count within one cell
 

One way:

=SUM(LARGE(A1:A4,{1,2,3}))/3


In article ,
"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

how to average and use sum min and count within one cell
 

Or more simply
=AVERAGE(LARGE(A1:A4,{1,2,3}))

Jerry

JE McGimpsey wrote:

One way:

=SUM(LARGE(A1:A4,{1,2,3}))/3


In article ,
"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

how to average and use sum min and count within one cell
 

Yeah, just a bit simpler...<g

Thanks for the correction!

In article ,
"Jerry W. Lewis" wrote:

Or more simply
=AVERAGE(LARGE(A1:A4,{1,2,3}))