The average for numerical values is calculated by adding all the numbers and dividing the sum of those numbers by the count of numbers.
Calculate Average in Excel with a Ribbon Option
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” tab.On the “Home” tab, from the “Editing” section, select the down-arrow icon next to the “Sum” option.In the expanded menu, click “Average” to find the average for your numbers.At the end of your selected cells, you will see the average for your numbers.Calculate the Average in Excel Including Zeros
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.
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.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
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.
Press Enter after typing the formula, and you will see the average for your numbers in your selected cell.
