Find the average (also called arithmetic average ) is useful in various calculations. Microsoft Excel makes it easy to calculate the average, and we’ll show you several ways to do it.
The average of the numerical values is calculated adding all the numbers and dividing the sum of those numbers by counting the numbers.
For example, if your numbers are 10, 15, 20, 25, and 30, you will first add all of these numbers and then divide that sum by 5 because you have a total of five numbers.
Here is the mathematical formula for that:
10 + 15 + 20 + 25 + 30/5 = 20
By default, when calculating the average, Excel ignores the blank cells, but consider cells that contain zeros. You can also make it ignore zero cells, as we’ll explain below.
A quick way to calculate the average in Excel is to use an option on the ribbon .
To use it, first, open your spreadsheet containing your numbers in Microsoft Excel. In your spreadsheet, select the numbers for which you want to find the average.
On the Excel ribbon at the top, click on the “Home” tab.
On the “Home” tab, in the “Editing” section, select the down arrow icon next to the “Sum” option.
In the expanded menu, click on “Average” to find the average of your numbers.
At the end of the selected cells, you will see the average of their numbers.
Similarly, you can also calculate a weighted average in Excel.
If your numbers are not in a continuous row or column, or if you want to enter values directly into the formula, use the
AVERAGEfunction Excel to find the average of their numbers.
For use function First, open your spreadsheet with Microsoft Excel. In your spreadsheet, click the cell in which you want to display the resulting average.
In the selected cell, type the following function and press Enter. Replace
C5in the function with the range where your numbers are.
= PROMEDIO (C2: C5)
If your numbers are in non-contiguous cells, individually specify those cells in the
AVERAGEfunction. Separate cells with a comma, as follows:
= PROMEDIO (D2, E2, F2)
If you want to directly use the numbers in the function, please enter your numbers in the function as shown below. Separate your numbers with a comma.
= PROMEDIO (10,15,20)
Press Enter after typing the formula and you will see the average of your numbers in the selected cell.
When calculating the average, Excel ignores blank cells and can make it ignore cells that contain as well zeros . To do this, you will use the
First, open your spreadsheet with Microsoft Excel. Then select the cell in which you want to display the result.
In the selected cell, type the following function and press Enter. In this function, replace
C5with the range where their numbers are.
= PROMEDIO SI (C2: C5, "> 0")
Excel will calculate the average ignoring cells that contain zeros.
And that’s it to find the average in Microsoft Excel. We hope it helps you.
Did you know that you can even calculate uncertainty in excel ?