AVERAGE
The AVERAGE function calculates the average of a set of values in Excel. It is useful for determining the central tendency of a dataset. Commonly used in data analysis and reporting.

Example explanation
Cell B7 uses the AVERAGE function to calculate the average score of the people mentioned.
Syntax 🔗
=AVERAGE(number1
, number2
, ...)
number1 | number2, ..., The numerical values for which you want to calculate the average. |
About AVERAGE 🔗
The AVERAGE function in Excel calculates the arithmetic mean of a set of numbers. It adds up the values you provide and divides the sum by the number of values. This function is useful for understanding the central value or trend of your data. Whether you're working with financial figures, academic data, or any other numerical information, the AVERAGE function helps you find the typical value in your dataset. Use it to get a quick insight into the average level or magnitude of your data.
Examples 🔗
Imagine you have a list of monthly sales figures for a year: $1500, $2000, $1800, $2500, $1900, and $2200. To find the average monthly sales, use the formula: =AVERAGE(1500, 2000, 1800, 2500, 1900, 2200).
If you have a range of cells with test scores in your worksheet, say B2:B10, use the formula: =AVERAGE(B2:B10) to determine the average test score from the specified range.
Notes 🔗
The AVERAGE function calculates the mean of only the numeric values in the given argument list or range. It ignores cells with non-numeric values or empty cells in the calculation.
Questions 🔗
The AVERAGE function omits non-numeric values and empty cells when computing the average. It only considers the numerical values provided as arguments or within the specified range.
Can the AVERAGE function handle a large set of values?Yes, the AVERAGE function can handle a large set of values provided as arguments, or within a range of cells. It efficiently processes the input values to deliver the arithmetic mean.
Is the AVERAGE function suitable for determining the median of a dataset?No, the AVERAGE function calculates the arithmetic mean of the input values and is not designed to determine the median. To calculate the median, you would use the MEDIAN function in Excel.