How to Calculate Mean in Excel
The mean, often referred to as the average, is a fundamental statistical measure that represents the sum of a set of values divided by the number of values in that set. In Microsoft Excel, you can easily calculate the mean using the AVERAGE function.
The AVERAGE function ignores blank cells and text entries within the specified range. If the range contains any error values (such as #DIV/0!), the AVERAGE function will also return an error.