Thread: How do I exclude the HIGH and LOW values in the =AVERAGE function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default How do I exclude the HIGH and LOW values in the =AVERAGE function
Do you want something like this:
=(sum(a1:a100)-max(a1:a100)-min(a1:a100))/(count(a1:a100)-2)
?

Regards.
Fred

"DeWayne" wrote in message
...
I want to exclude the MAX and MIN values in the range for the AVERAGE
function.

Reply With QuoteReply With Quote