Windows & Other OS

How to calculate the average in Microsoft Excel

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.

What is the average in Excel?

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.

Calculate Average in Excel with a Ribbon Option

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.

Select cells with numbers in Excel.

On the Excel ribbon at the top, click on the “Home” tab.

Click on the tab

On the “Home” tab, in the “Editing” section, select the down arrow icon next to the “Sum” option.

Please select

In the expanded menu, click on “Average” to find the average of your numbers.

Choose

At the end of the selected cells, you will see the average of their numbers.

Average of the selected numbers.

Similarly, you can also calculate a weighted average in Excel.

Calculate the average in Excel including zeros

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.

Select a cell to display the average.

In the selected cell, type the following function and press Enter. Replace C2Y C5in the function with the range where your numbers are.

= PROMEDIO (C2: C5)

Enter the AVERAGE function.

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)

Enter values ​​directly into the AVERAGE function.

Press Enter after typing the formula and you will see the average of your numbers in the selected cell.

The result of the AVERAGE function.

That’s it.

Calculate average in Excel excluding zeros

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 AVERAGEIFfunction.

First, open your spreadsheet with Microsoft Excel. Then select the cell in which you want to display the result.

Select a cell to display the average.

In the selected cell, type the following function and press Enter. In this function, replace C2Y C5with the range where their numbers are.

= PROMEDIO SI (C2: C5, "> 0")

Write the AVERAGE IF function.

Excel will calculate the average ignoring cells that contain zeros.

The result of the AVERAGEIF function.

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 ?

RELATED:   Buy a used GPU? This is what to look for

Related posts

Leave a Comment