How to average with and without the highest and lowest values in Excel

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.

Image: Wachiwit/Shutterstock

The article How to do more advanced averaging in Excel reviews Microsoft Excel’s many averaging functions. The focus is how the functions evaluate zero and Boolean values and empty string values. These functions won’t always be adequate, though. In fact, sometimes you’ll need an expression that doesn’t use any averaging functions at all. In this article, we’ll look at some unique averaging solutions.

SEE: 69 Excel tips every user should master (TechRepublic)

I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier…

Keep reading the full content on the TechRepublic site.

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Spread the love

Leave a Comment