The purpose of AVERAGE function is to get an average number of a set.
Figure 1: Example showing how to use the Excel AVERAGE function to find the average sales from different sales reps for three days.
In the example above, the formula in F7 is:
This is dragged down to auto-fill the table.
How it works
The AVERAGE function works automatically in Excel. Often times you only have to provide an array of cells to find the average, and the Excel AVERAGE function will automatically display the result. If you wish, you can also input arguments individually. However, this happens where the cells are apart from each other.
- The Excel AVERAGE function will automatically ignore blank cells, texts, and Zero value in the calculation.