AVERAGE Function in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> AVERAGE Function in Excel



In this tutorial, you will learn about how to use excel AVERAGE formula to calculate median in this spreadsheet software. AVERAGE function in excel has a quite easy usage method which is by inputting all the digits that you want to calculate into the formula to get the result.


Why We Need to Learn About Excel AVERAGE Formula?


In processing digits saved in spreadsheet software, often we need to find the median of some or all of our digits. In the case such as looking to find the general picture of company products performance in a particular segment for a period of time or seeing how much is the profit of our business branch daily in a particular region, then the approach like calculating the median for all of our products performance for the first case or the middle digit of all our company branches profit in the region will be the results we need to get to do further analysis with those data collections.

For this matter, there is excel AVERAGE formula which can be used to make the calculation process easier. AVERAGE function in excel itself is very easy to learn and practice so it is hoped that it can make our work significantly more effective and efficient when we process our digits in this tool.


What is AVERAGE Function in Excel?


Excel AVERAGE formula is basic formula in this spreadsheet software with the usage objective to find middle number from some or all of our digits. By using it, we just need to input all of the numerals that we want to process to the AVERAGE function in excel. This method is actually the basic one in looking for middle number in this spreadsheet. If you want to find result using digits with particular condition, then you can use AVERAGEIF and AVERAGEIFS to help you. The tutorials on how to use both can also be found in this blog.

A brief explanation on the inputs in this formula is as follows:


=AVERAGE(number1, number2, …)


Note:
number1, number2, … = all the numbers that you want to calculate the average from


How to Use Excel AVERAGE Formula?


The following will explain step by step on how to use AVERAGE function in excel. In using this excel AVERAGE formula, we need to prepare digits to be calculated for the median result first, either by putting them in cells or by inputting directly when we write the formula.


Using AVERAGE Function in Excel

  1. Type equal sign ( = ) in the cell where you want to put the calculation result

    AVERAGE Function in Excel - Screenshot of Step 1

  2. Type AVERAGE (can be with large and small letters) and open bracket sign after =

    AVERAGE Function in Excel - Screenshot of Step 2

  3. Type the numbers or cell coordinates where you put the numbers to be processed are after open bracket sign with comma sign ( , ) between the numbers or cell coordinates or drag cell cursor from the most top left cell coordinate to the most bottom right if the number cells you want to process are close to each other

    AVERAGE Function in Excel - Screenshot of Step 3

  4. Type close bracket sign after all the numbers or cell coordinates filled with numbers have already been inputted

    AVERAGE Function in Excel - Screenshot of Step 4

  5. Press Enter
  6. The process is done!

    AVERAGE Function in Excel - Screenshot of Step 6



Exercise


After you learn from the excel AVERAGE formula tutorial above, you can practice your understanding about it using this exercise!

Download file from the following link and answer the questions below. Please download the answers if you have done the calculation process and sure about the result!

Link to download file to practice your understanding of using excel AVERAGE formula:
Download here

Questions

  1. What is the median calculation result for B1:B10?
  2. What is the median calculation result for C1:C10?
  3. What is the median calculation result for D1:D10?

Link to download answer:
Download here


Additional Notes

  • In using this formula, drag cell cursor and numbers or cell coordinates input with comma sign separation can be done in one writing
  • If you want, cell coordinates which are near to each other can also be written manually separated for the most top left cell and most bottom right cell by two dots sign ( : ) (writing example: B1:D25)
  • There are some other ways to find median number in this spreadsheet software which is by using slash sign ( / ) manual method, AVERAGEIF, and AVERAGEIFS. These methods can be learned by you on how to use it in the other parts of this Compute Expert tutorial blog!




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert