View Single Post
  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default 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}))