Thread: Average Formula for the smallest x of xx values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Average Formula for the smallest x of xx values
This will average the 3 smallest numbers in the range:

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

--
Biff
Microsoft Excel MVP


"Keith K" <Keith wrote in message
...
Any suggestions?


Reply With QuoteReply With Quote