You could try something like
=AVERAGE(IF((dataPERCENTILE(data,20%))*(data<PERC ENTILE(data,40%)),data))
array entered (Ctrl-Shift-Enter). Ties could be problematic, but they are
with TRIMMEAN as well, since TRIMMEAN{1,1,1,1,1,1,1,1,2,2},10%) should return
1.125=(7*1+1*2)/8 but instead returns 1.2.

Jerry

" wrote:

The TRIMMEAN function gives you the average of the interior of a
distribution, where you cut x% from both the top and the bottom.

Is it possible to easily modify the percentages, so I could find the
average between specific percentiles? Say, finding the average of the
values between the 20th and 40th percentiles, rather than just trimming
out on either end? (In this example, I know I could use PERCENTILE to
just find the 30th percentile to get close, but in the data I'm using
it would be better to get an average of a group.)

Thanks very much,

Andrew