Excel function AVERAGE

The AVERAGE function returns the average of a series of numbers.

1st method

Select the AVERAGE function. Enter a data range in "Number1" and then click OK.

average function - average

The average will be displayed.

average - average

2nd method

Select the AVERAGE function. Enter one cell in each box (up to 255 boxes will be added automatically) and then click OK.

average function2 - average

The average will be displayed.

average2 - average

The 2nd method is generally used when the numbers to be averaged are dispersed on the sheet.