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.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar