# EXCEL FUNCTION – AVERAGE

## How to use “AVERAGE” function in Excel

AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items

AVERAGE Function has one required argument i.e. number1, and optional argument i.e. [number2].

##### Syntax:
`=AVERAGE(number1,[number2],...)`
##### Syntax Description:

number1 argument is used to number value/cell reference/range for which average is required

[number2] argument is used to another number value value/cell reference/range

means, we can add multiple value/cell reference/range by separating them with comma ( , )

##### Example 1: AVERAGE function with cell range:
• “Column A” has number values,
• “Column B” shows the sample formula applied,
• “Column C” shows the output of the function and,
• Explanation is provided in “Column D”
##### Example 2: AVERAGE function with Number Values:
• “Column A” shows the sample formula applied, which contains the list of numbers. Each number are separated by comma ( , )
• “Column B” shows the output of the function and,
• Explanation is provided in “Column D”

Hope you learnt this Function,