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. RELATED: How to Find the Mean in Microsoft Excel 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. RELATED: How to Count Blank or Empty Cells in Microsoft Excel 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. In Excel’s ribbon at the top, click the “Home”… Click below to read the full story from How To Geek
Read More