Thread: Average Formula for the smallest x of xx values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Average Formula for the smallest x of xx values
Hi,

Maybe this

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

Averages the 3 smallest values in A1 - a10.

Mike

"Keith K" wrote:

Any suggestions?
Reply With QuoteReply With Quote