How to Use Excel AVERAGE Function?

Ads

Listen to this article

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 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:

Sridhar

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.