Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
  - AVEDEV
  - AVERAGE
  - AVERAGEA
  - AVERAGEIF
  - AVERAGEIFS
  - BETA.DIST
  - BETA.INV
  - BINOM.DIST
  - BINOM.DIST.RANGE
  - BINOM.INV
  - CHISQ.DIST
  - CHISQ.DIST.RT
  - CHISQ.INV
  - CHISQ.INV.RT
  - CHISQ.TEST
  - CONFIDENCE.NORM
  - CONFIDENCE.T
  - CORREL
  - COUNT
  - COUNTA
  - COUNTBLANK
  - COUNTIF
  - COUNTIFS
  - COVARIANCE.P
  - COVARIANCE.S
  - DEVSQ
  - EXPON.DIST
  - F.DIST
  - F.DIST.RT
  - F.INV
  - F.INV.RT
  - F.TEST
  - FISHER
  - FISHERINV
  - FORECAST
  - FORECAST.LINEAR
  - FREQUENCY
  - GAMMA
  - GAMMA.DIST
  - GAMMA.INV
  - GAMMALN
  - GAMMALN.PRECISE
  - GAUSS
  - GEOMEAN
  - GROWTH
  - HARMEAN
  - HYPGEOM.DIST
  - INTERCEPT
  - KURT
  - LARGE
  - LINEST
  - LOGEST
  - LOGNORM.DIST
  - LOGNORM.INV
  - MAX
  - MAXA
  - MAXIFS
  - MEDIAN
  - MIN
  - MINA
  - MINIFS
  - MODE.MULT
  - MODE.SNGL
  - NEGBINOM.DIST
  - NORM.DIST
  - NORM.S.DIST
  - NORM.S.INV
  - NORMINV
  - PEARSON
  - PERCENTILE.EXC
  - PERCENTILE.INC
  - PERCENTRANK.EXC
  - PERCENTRANK.INC
  - PERMUT
  - PERMUTATIONA
  - PHI
  - POISSON.DIST
  - PROB
  - QUARTILE.EXC
  - QUARTILE.INC
  - RANK.AVG
  - RANK.EQ
  - RSQ
  - SKEW
  - SKEW.P
  - SLOPE
  - SMALL
  - STANDARDIZE
  - STDEV.P
  - STDEV.S
  - STDEVA
  - STDEVPA
  - STEYX
  - T.DIST
  - T.DIST.2T
  - T.DIST.RT
  - T.INV
  - T.INV.2T
  - T.TEST
  - TREND
  - TRIMMEAN
  - VAR.P
  - VAR.S
  - VARA
  - VARPA
  - WEIBULL.DIST
  - Z.TEST
- Text Functions
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

TRIMMEAN

This function returns the mean of a subset of data excluding the top and bottom data.

Syntax

TRIMMEAN(array, percent)

Arguments

This function has these arguments:

Argument	Description
array	[Required] Array of values to trim and find the mean
percent	[Required] Fractional amount of data in array to trim (to exclude from calculation)

Examples

TRIMMEAN(A1:A17,0.25)