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

ArgumentRequired?What it does
arrayYesThe range of numbers.
percentYesThe 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)
ABC
1DaysTrimmed mean
223
33Average
434.1
54
63
72
815
93
104
112
=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.
Kyle Stott

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.