## How to Calculate an Average in Excel Ignoring 0

The AVERAGE() function in Excel will include zeros in calculating the mean value of a dataset. In some cases, however, you’ll want to exclude these values from your calculation. In this tutorial, you’ll learn how to calculate an average in Excel while excluding 0. Excel makes calculating an average in Excel while excluding zeros easy …