=AVERAGE(IF(DataMin,IF(Data<Max,Data,"")))

entered as an array formula with Ctl-Shift-Enter instead of Enter
alone,

calculates the average, and there may be no useful phrase that would
take you to the appropriate Help, because it is probably not there.

Data is a named range containing the values, Max and Min are your
outlier limits

Use <= and = if your Max and Min are ceilings and should be included.

Substitute MEDIAN for AVERAGE to get median.

HTH

DOR