Ms Excel- Formula for extracting average in excel tips for beginner

Average, this formula is used to calculate average in MS Excel, it is very easy, just like you use Average Formula in math, similarly the average can be extracted in MS Excel as well. Auto Average can also be calculated.

First, let us see what is the average formula in maths -

Average = sum of numbers on list ÷ amount of numbers in list

That is, the sum of the numbers given in the list is 6.

For example - If an average of 2, 4, 6, 8 is to be obtained

2 + 4 + 6 + 8 ÷ 4 = 5

Now similarly we extract the average in MS Excel –

In MS Excel, the formula for Average is -

= AVERAGE (number 1, number…)

For example - if you have to calculate the average of numbers from cell e1 to cell e7, then you have to type this formula -

8450447_f520

= AVERAGE (e1: e7)

In this formula, the number written in bracket is your cell range. Formula The second way to calculate the average of these numbers in MS Excel can also be done by first summing these numbers and then dividing them by 4.