Thread: average out of bottom 10 values
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default average out of bottom 10 values
Hi,

If by lowest you mean last 20 values, then use
=AVERAGE(OFFSET(G23,-9,,10,1)) where G23 is the 20th value. fi by lowest
value you mean the smallest 10 numbers, then use
=AVERAGE(SMALL(G4:G23,{1,2,3,4,5,6,7,8,9,10}))

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"picks72" wrote in message
...
I have 20 values in a row or column and what to average the lowest 10
values
of these 20. Is there a formula I can use?

Reply With QuoteReply With Quote