Thread: how to average and use sum min and count within one cell
View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote