# How to Use Excel AVERAGE Function?

Sometimes, we want to find the average value of the set of input values. Doing this manually is quite difficult for you. So, we suggest you use the built-in function of Excel to do this task for you. With the help of the AVERAGE function, we can quickly get the average value. If you want to know how to use this.

Then this tutorial will guide you to learn the usage of Excel AVERAGE Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of AVERAGE Function

• It is one of the built-in functions in Excel.
• This function returns the arithmetic mean of given input numbers.
• It will accept up to 255 arguments that can be numbers, arrays, cell references, ranges, and constants.

## Syntax

• Here, you will see the syntax of the AVERAGE function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

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

Arguments Explanation:

Number 1 – It is the first input number, cell reference, or range.

Number 2 – It is an optional one. This is the second input number, cell reference, or range.

Note:
1) If the arguments contain Text, Logical values, or Empty cells, they will be ignored.
2) This function includes zero values.

## Practical Examples

Let’s see some examples to understand this concept quickly.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For example, we have entered the list of student’s marks in the range A2:D5. And we are going to get the average mark of each student.
• Then, we entered the above-mentioned formula in Cell F2. to get the result.
• To get the result, you have to click on the  button on your keyboard. Then, you will need to drag down the cells to fill the remaining range of cells.

## Ignores Blank Cell

• As we mentioned earlier, If the arguments contain Text, Logical values, or Empty cells, they will be ignored, and this function includes zero as values.
• In the following image, you have seen all these values. Then we apply the AVERAGE function to get the result.
• Finally, you have to click the button to get the output value.

## Conclusion

In this tutorial, we guided you to learn the usage of Excel AVERAGE Function in Office 365 with its syntax, description, and examples. Kindly, leave your feedback in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

In this video, you will learn the usage of the AVERAGE function in Excel.