Average numbers

An excel formula to average numbers

Related Functions

Sponsored Link

 Average numbers
=AVERAGE(range)

To get the average of a set of numbers, use the AVERAGE function.

In the example shown, the formula in E5 is:

 
=AVERAGE(B5:D5)

which is then copied down the table.

How this formula works

AVERAGE is an automatic function in Excel. In most cases, you'll supply a range of cells to average, and the function will return the result. However, you can also supply individual arguments to the function, in cases where cells are non-adjacent.

Note that AVERAGE automatically ignores blank cells and text, but zero values are included.

Sponsored Link

0 votes. 0 / 5