Thread: Formula for 6 lowest #'s in a range then average of them.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Formula for 6 lowest #'s in a range then average of them.
Hi,

=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))

Mike

"Douno" wrote:

Need a formula that will pick out the 6 lowest numbers in a range, then give
an average of those 6 numbers. Can anyone help?
Reply With QuoteReply With Quote