How to calculate Average value in Excel

Average value calculation can be helpful in many use cases. There can be a need to find average spend volume, or average transaction volume, or average height etc. Average function helps average value calculation in Microsoft Excel. Average function is one of the frequently used function along with Sum, Max, Min functions. How to calculate Average value in Excel? learn in easy steps with the help of this article.

John has customer spend data for his company. He is looking foward to calculate average spend for all the customers. He is also looking forward to calculate average spend for specific customers, 1, 2 and 4. We will look into both the examples.

Calculate Average value for Entire Column in Excel

To find average value for all the values in a column, below syntax helps:

=AVERAGE(J5:J24)

Here, this formula helps in finding the Average of all the values from J5 to J24 (i.e. J5, J6, J7 …. J24). You can see below, with the help of the formula average value is obtained easily.

To get top certifications in Microsoft Excel and build your resume visit here. Also, you can read books listed here to build strong knowledge around Microsoft Excel.

How to find Average value of random cells in Excel

In the second example, we are trying to find average value of some random cells. Here we are trying to find average value of Yearly spend of Customer ID 1, 2 and 4. These corresponds to cell number J5, J6 and J8. Below is the formula that will help to achieve the results.

=AVERAGE(J5,J6,J8)

This calculates the average value of some random cells. To achieve more such calculation, you can add cells with comma separation. Below is the formula results.

Please visit our video tutorial to go through the example as well:

Share your feedbacks if you like the article. Like and share for more such content.