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

## Jump To

## 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**Enter**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**Enter**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**Enter**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.

**See Also:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

Hi there, I’m **Sridhar** – an Excel enthusiast with over **10 years** of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their **operations and save time and money**.

Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.