TRIMMEAN Function
Returns the average after trimming a percentage of the highest and lowest values.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Want to practice TRIMMEAN in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
TRIMMEAN drops a share of the values from the top and bottom, then averages the rest — a middle ground between AVERAGE and MEDIAN that ignores outliers.
The number of values trimmed is rounded down to an even number and split equally between top and bottom.
Syntax
=TRIMMEAN(array, percent) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array | Yes | The range of numbers. |
| percent | Yes | The share of values to drop in total, from 0 to just under 1 (0.2 = 20%, half from each end). |
Examples
Example 1 — Delivery days without the outlier
One delivery took 15 days. Trimming 20% of 10 values drops 2 — the 15 and the lowest 2.
C2fx=TRIMMEAN(A2:A11,0.2)
| A | B | C | |
|---|---|---|---|
| 1 | Days | Trimmed mean | |
| 2 | 2 | 3 | |
| 3 | 3 | Average | |
| 4 | 3 | 4.1 | |
| 5 | 4 | ||
| 6 | 3 | ||
| 7 | 2 | ||
| 8 | 15 | ||
| 9 | 3 | ||
| 10 | 4 | ||
| 11 | 2 |
=TRIMMEAN(A2:A11,0.2) Explain
Common mistakes
- Nothing trimmed. With 7 values, 20% is 1.4, rounded down to 0 — nothing is dropped. Trim at least 2/n to remove one value from each end.
- #NUM! percent is below 0 or 1 or more.
Notes
- Judging panels often use this idea: drop the highest and lowest score, then average.
- Related functions: AVERAGE, MEDIAN, AVERAGEIFS.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.