An alternative Excel averaging formula that doesn’t evaluate zero Your email has been sent Excel's AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives.

Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For ...