Home DIGITAL SKILLS How to Calculate Average in Microsoft Excel

How to Calculate Average in Microsoft Excel

221
0
How To Count Blank - Empty Cells In Microsoft Excel How to Compare Two Lists in Microsoft Excel How to Add Numbers in Microsoft Excel If you need to get the sum of two or more numbers in your spreadsheets, Microsoft Excel has multiple options for addition. We’ll show you the available ways to add in Excel, including doing it without a formula.

How to Calculate Average in Microsoft Excel

Finding the average (also called the arithmetic mean) comes in handy in various calculations.

Microsoft Excel makes it easy to calculate the average, and we’ll show you multiple ways to do that.

What Is Average in Excel?

The average for numerical values is calculated by adding all the numbers and dividing the sum of those numbers by the count of numbers.

For example, if your numbers are 10, 15, 20, 25, and 30, you will first add all these numbers and then divide that sum by 5 because you have a total of five numbers.

Here’s the mathematical formula for that:

10+15+20+25+30/5 = 20

By default, when you calculate the average, Excel ignores any blank cells but it does consider the cells containing zeros. You can make it ignore zero cells, too, 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.

In Excel’s ribbon at the top, click the “Home” tab.

Click The &Quot;Home&Quot; Tab In Excel.

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

Select &Quot;Sum&Quot; In The &Quot;Home&Quot; Tab.

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

Choose &Quot;Average&Quot; From The Menu.

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

Average For The Selected Numbers.

In a similar way, you can also calculate a weighted average in Excel.

Calculate Average in Excel Including Zeros

If your numbers are not in a continuous row or column, or if you’d like to directly enter values in the formula, then use Excel’s AVERAGE function to find the average for your numbers.

  Characteristics And Importance of Good Black Board

To use the 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 C2 and C5 in the function with the range where your numbers are.

=AVERAGE(C2:C5)

Enter The Average Function.

If your numbers are in non-contiguous cells, then individually specify those cells in the AVERAGE function. Separate the cells by a comma, as follows:

=AVERAGE(D2,E2,F2)

If you’d like to directly use the numbers in the function, then enter your numbers in the function as below. Separate your numbers with a comma.

=AVERAGE(10,15,20)

Enter Values Directly In The Average Function.

Press Enter after typing the formula, and you will see the average for your numbers in your 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 you can make it ignore the cells containing zeros, too. To do so, you will use the AVERAGEIF function.

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 C2 and C5 with the range where your numbers are.

=AVERAGEIF(C2:C5,">0")

Type The Averageif Function.

Excel will calculate the average ignoring any cells containing zeros.

The Result Of The Averageif Function.

And that’s all three is to finding the average in Microsoft Excel. We hope it helps you.

YOU MUST ALSO READ THIS

How To Log In and Use Mfumo wa Taarifa za Shule SIS (School Information System) Mkuu wa Shule
How To Log In and Use Mfumo wa Taarifa za ...
How To Reduce Mobile Data Usage On Android device
How To Reduce Mobile Data Usage On Android device
  How To Backup GBwhatsapp To Google Drive 2021
It's important ...
How to Use the COUNT Function in Microsoft Excel
How to Use the COUNT Function in Microsoft Excel Counting how ...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

error: Content is protected !!