Average number

General Formula 



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. 
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment