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.