Go Back

Excel AVERAGE Function

Excel Average Function

The Excel AVERAGE function helps you get the average sum of the selected numbers provided on an Excel spreadsheet. This is fairly a common function in the Excel app and it is typified as the Statistical Function. The Excel AVERAGE function is really an easy way to get straight to the Average sum on any Excel task.

Syntax

AVERAGE( number1, [number2], ... [number_n] )

More Explanation

The Excel Average Function is quite useful when you want to mark out a line of basic expectation from an outcome. A perfect instance of this is trying to get the average expected score of students. In a group of students with varying exam scores, you want to get the average score that applies to all of them.

The average score in this instance will be the expected average mark the students in the group should get. The easiest way to do this is through the simple method of the Excel Average function.

Example

Using the situation provided above, let’s make an Excel spreadsheet of a class of 9 pupils with different scores with the aim of getting the average score of all students.

Step 1

Make sure the all the data are entered correctly and in the appropriate cell before attempting to use the Average function.

Figure 1. Input data for AVERAGE function

Step 2

Properly highlight the cells you want to get the average score on. In the table shown above, we want to get the average function on cells B2 to B9. That means the whole of cells B2, B3, B4, B5, B6, B7, B8, and B9.

Figure 2. Highlight the cells to get the average score

Step 3

Go to the Formulas Menu as shown in the table above, pick the submenu AutoSum, a drop-down menu will appear, then click on average to get the average score. Doing this will give your average score on B10.

Figure 3. Using Average function example

Notes

  • You can provide Numbers as any of many forms, including numbers, named ranges, ranges, or cell references that have numeric characteristics in them.
  • The AVERAGE function does not consider empty cells and instinctively ignores them.

 

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Modify the two Values fields to determine the average Issue Price and average Est. Value by type. Change the custom name to Average Issue Price and Average Est. Value, respectively.
Solved by G. F. in 19 mins
Which of the following will calculate the mean value of a series of numbers stored between the cells A5 to A20 inclusive? Tick all that apply =average($a$5:a20) =AVERAGE(A1:A20)-AVERAGE(A1:A4) =MEAN(A5:A20) =AVERAGE(A5:A20) =AVERAGE(A8:A20,A5,A6) =SUM(A5:A20)/COUNT(A5:A20)
Solved by X. C. in 29 mins
Why is my average value for my total hours/day column showing the wrong value. I used the average formula to take the average off all the rows.
Solved by M. H. in 30 mins

Leave a Comment

avatar