Excel Average Formula (Table of Contents)
Average Formula in Excel
Average formula in excel simply gives the average of selected numeric cell values. Average means if we take out the sum of some values and divide that with calculated sum with the total number of iterations, gives the average of all the values.
How To Use Average Formula in Excel?
In our school days, we used to calculate the average of any range by summing the values first then dividing the same with the total number of values used in sum. But in excel we have a simple formula for calculating an average. For this, from the Insert Function option in excel, we can search AVERAGE to use it.
Or else go to edit mode of any cell by typing = (equal sign) and then select average function from it as shown below.
Average Formula in Excel – Example #1
Let’s understand How to use Average Formula in Excel with some examples.
We have a sample data of sale of a product of 10 days as shown below.
Now let’s calculate the average sales of given data. For this, go to the cell where we want to apply the average formula to see the result and then click on Insert Function icon just beside the Formula bar in excel as shown below.
4.8 (1,370 ratings)
Or Go to Formulas Tab and Select Insert Function as shown below.
After that, we will get an Insert Function box as shown below. From there search for Average function and then click OK. Or else, we can locate Average function in Statistical functions category from Or select a category box.
As we can see above, after selecting the function, we will get the syntax suggestion also which is highlighted in the box.
Once we click on OK, it will take us to the Average Function Argument window. There, select the cells or range for which we need to find the average. Here we can select more than 1 range in a different number of cells. After that click on OK.
As we can see, we got the average of selected range as 33.6 for the selected range B2 to B11.
This is already noticed by many people, the same result will be visible at the bottom of the excel sheet as shown below. There we can see the total selected cells, the sum of all the numbers and average of selected numbers.
Average Formula in Excel – Example #2
This is another way to take an average. We will consider the same data which we have seen above for taking an average. This is a simple and quick way to get the required result. For this, go to the cell where we want to see the output. Now type = (Equal sign) to go in edit mode of that selected cell. Now type AVERAGE and select the exact function as shown below.
As we can see, the syntax of the selected function is also been seen. We see work as per that as well. Now to complete the syntax select the range of cells for which we need to calculate the average.
Here we have selected the range from cell B2 to B11 cell as shown below.
And then press Enter to get the result. As we can see the average of selected cells is 33.6 as shown below.
For this case also we can check at the bottom of the excel sheet whether it is showing the same average or not. For this, select the cells and go down.
As we can see above, it is showing the same average as 33.6 for selected cell count 10. This proofs the exactness of the formula we used.
Average Formula in Excel – Example #3
We can get more precise results if we use AVERAGE with ROUND. This will give the round figure result instead of a figure with decimal digits. For this, Add ROUND function once we apply the AVERAGE. Press = in any cell and search and select ROUND function. Here we can see the syntax of ROUND as shown below.
It says number and num_digits are the part of the syntax. Now for number, apply the AVERAGE Formula and for num_digits select as shown below.
This will give us the average of selected range without any decimal digit count. The result will be in the whole number.
Things to Remember
- Always select the complete range. If there are blank cells in between, select the cell as well to fill the gap.
- We can get the result in round figures by using ROUND function before AVERAGE as explained in an example -3.
- AVERAGE function can be used vertically, horizontally or in any matrix shaped data in any form.
This has been a guide to Average Formula in Excel. Here we discussed Average Formula in Excel and how to use Average Formula in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –