Thread: formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default formulas
With your values in A1 to A10. Try and feedback

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

If this post helps click Yes
---------------
Jacob Skaria


"FUNACH" wrote:

need to average lowest 6 out of 10 cells?
Reply With QuoteReply With Quote