How to Use Excel TRIMMEAN Function in Office 365? – {with Examples}
Tags: excelfunctions, exceltrimmeanfunctio
Published: 2020-09-19 10:38:53

---
title: How to Use Excel TRIMMEAN Function in Office 365? – {with Examples}
published: true
date: 2020-09-19 08:07:15 UTC
tags: ExcelFunctions,ExcelTRIMMEANFunctio
canonical_url: https://geekexcel.com/how-to-use-excel-trimmean-function-in-office-365-with-examples/
---

## Excel TRIMMEAN Function:

![TRIMMEAN Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/TRIMMEAN-Function.png)<figcaption id="caption-attachment-14267">TRIMMEAN Function</figcaption>

In this post, you will learn the usage of **Excel TRIMMEAN Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **TRIMMEAN Function – Explanation:**

- This function **calculates the mean by excluding the percentage of data points from the top & bottom of the data set.**
- TRIMMEAN function rounds the number of excluded data points down to the nearest multiple of 2.

## Syntax:

**=TRIMMEAN(array, percent)**

### Arguments Explanation:

**Array – ** The array or range of values to trim and get average.

**Percent – ** The number of data points to be excluded from the calculation. For example, 10 percent of 20 data points is equal to 2 points. So, this function excludes one value from the top & bottom of the data set.

### Note:

- If the percent is **less than 0 or greater than 1** , then it returns [**#NUM!**  **Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- This function ignores the **Text** , **Logical**  **values** , **Blank**  **cells** , and **Special**  **symbols**.

## Examples:

Let’s see some examples to understand how this function works.

### Example 1:

- In the below screenshot, you can see the **input**  **range** in **Column**  **B** , and its output **TRIMMEAN**  **value** is displayed in the **cell**  **D4**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-75.png)<figcaption id="caption-attachment-14263">Example 1</figcaption>

### Example 2:

- If the percent is **less than 0 or greater than 1** , then it returns [**#NUM!**  **Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-70.png)<figcaption id="caption-attachment-14264">Example 2</figcaption>

### Example 3:

- This function ignores the **Text** , **Logical**  **values** , **Blank**  **cells** , and **Special**  **symbols**.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-33.png)<figcaption id="caption-attachment-14265">Example 3</figcaption>

From the above examples, you can clearly understand how to use the **TRIMMEAN** function.

### Video Tutorial:

<video id="video-14262-2" width="770" height="433" preload="metadata" controls="controls"><source type="video/mp4" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/My-Movie_1.mp4?_=2"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/My-Movie_1.mp4">https://geekexcel.com/wp-content/uploads/2020/09/My-Movie_1.mp4</a></video>

## Verdict:

In the above article, you can understand the usage of **Excel TRIMMEAN Function in Office 365** with its syntax, explanation, and examples. Kindly, leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel PERCENTRANK Function in Office 365?](https://geekexcel.com/how-to-use-excel-percentrank-function-in-office-365/)
- [How to Use Excel PERCENTILE.EXC Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-percentile-exc-function-in-office-365-with-examples/)