Average is calculated by adding a group of numbers and then dividing the total sum by the total number of items. The Average formulas used in Excel are:  =AVERAGE(number1, [number2], …) ... =AVERAGE(B2:B11)