How to Calculate the Average Value of Data with Excel Function

Date:2019-10-30 Author:Cordelia

Calculating the average value is a very common way to analyze data in Excel. To do the computations accurately and also rapidly, you can use Excel function to calculate mulitple, or even an entire column of data. Here’s the basic approach to use AVERAGE functin.

1. Select the E2 cell, Click FormulasAutoSumAverages (or you can input “=AVERAGE(B2:D2)” directly).

How to Calculate the Average  Value of Data with Excel Function

In this formula, B2:D2 refers to B2 to D2 (including C2), the range of cells you want to evaluate.

How to Calculate the Average  Value of Data with Excel Function

2. Press [Enter] key and you can see the result.

How to Calculate the Average  Value of Data with Excel Function

3. If you want to evaluate the average value in E3, E4 and E5 as well. Don’t bother to input the formula in each cell. Just click the lower right corner of E2 till the cursor become a black cross, drag it to contain all these cells. The average formula will run in each of them automatically.

How to Calculate the Average  Value of Data with Excel Function

How to Calculate the Average  Value of Data with Excel Function

4. If you think there’re too many decimal digits, choose the cells and find Increase Decimal and Decrease Decimal in Home tab.

How to Calculate the Average  Value of Data with Excel Function

Use these two button to customize the decimal digits in the sheet as you like.

How to Calculate the Average  Value of Data with Excel Function

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

One response to “How to Calculate the Average Value of Data with Excel Function”

  1. vurtilopmer says:

    Your style is so unique compared to many other people. Thank you for publishing when you have the opportunity,Guess I will just make this bookmarked.2

Leave a Reply

Your email address will not be published. Required fields are marked *