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

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. 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) 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. 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. 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") 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 ?

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