AVERAGE Function

Purpose of the Function

The AVERAGE function in Excel (and many other spreadsheet programs) is used to calculate the average, or mean, of a range of numbers.

Syntax

=AVERAGE (number1, [number2], ...)

number1, number2, ...: These are the numbers or cell references containing numbers that you want to include in the average calculation. You can input up to 255 arguments.

Practical Example

Step -01 : Call Average Function:

Select the Cell, Which You Want to Apply the Function and Write Average Function =Average in Selected Cell Or Range.

Step -02 : Enter Average Arguments:

We need to select Cells or Range, which you Want to Calculate the Average Value with in the Brackets.

Step -03 : Hit The Enter Key :

After Entering the Average Function, we need hit The Enter Key, The Excel Calculate the Average Values Which We Selected Cells or Range.

Step -04 : Drag Or Double Click in the Plus Sign (+):

If You Drag Your mouse In the Bottom of Right Corner in F2 cell, You Are Able To See Plus Sign (+), If you Double Click in The Plus Sign (+) The Excel Automatically Calculate Average Value for Entire Cells or Click On Plus Sign (+) And Drag Up to Last Cell.

The AVERAGE function adds up all the numbers provided as arguments and divides that sum by the count of numbers. It's a useful tool for obtaining a central value that represents the "average" of a set of data points.