Ignore Zeros when Finding the Average

Ignore Zeros when Finding the Average
© Ted French

While the AVERAGE Function is very useful when it comes to finding the arithmetic mean for a range of data, it does have limitations.

For example, if you want to exclude certain data from the data that throws off the average - such as zero values - the AVERAGE function can't do it.

Fortunately, Excel has another function that can handle specific situations such as ignoring zero values when finding the average - it's called AVERAGEIF.

By allowing the user to set conditions on what data gets averaged, this function can easily accommodate this type of situation.

To find out all the details, read this short tutorial on Ignore Zeros when Finding the Average.

Related Tutorials

• Excel AVERAGEIF Function Step by Step Tutorial
• Excel AVERAGEIFS Function Step by Step Tutorial
• Calculate Weighted Average in Excel