Microsoft Excel AVERAGE function is one of the “Statistical” and most commonly used function in Excel. It is the arithmetic mean of the arguments. AVERAGE formula is calculated by adding the sum of the cells and then dividing the total by the number of cells in the argument.