View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Averaging without the highest or lowest values

=TRIMMEAN(A1:A10,0.2)


--


Regards,


Peo Sjoblom



"leadfoot" wrote in message
...
I've tried Excel help and played around with formulas, and I can't find
anything for what should be a pretty simple issue: I want to calculate
averages on a series of values for each month, while discarding the
highest
and lowest values.

Perhaps I just didn't word it right when using Excel help, but no results
were helpful ...

Thanks!