AVERAGE Function

Basic Description

The Excel AVERAGE function returns the arithmetic mean of a list of supplied numbers.

Syntax: AVERAGE( number1, [number2], … )

where the number arguments are a set of one or more numeric values, or arrays of numeric values, for which you want to calculate the average – these values can be supplied directly to the function, or as one or more cells or ranges of cells containing numeric values.

In Excel 2007 & Excel 2010, you can provide up to 255 number arguments to the Average function, but in Excel 2003, the function can only accept up to 30 arguments. However, each argument can consist of an array of values or a range of cells, each of which can contain many values.

 

Excel Average Function Examples

Average Function Example-1

The following spreadsheet shows the Excel Average function used to calculate the arithmetic mean of the set of values in cells A1-A5. Although the same 5 values are provided to each of the functions in cells B1-B4, in each case, the values are provided to the function in different ways.

 Formulas:
A B
1 8 =AVERAGE( A1:A5 )
2 7 =AVERAGE( 8, 7, 9, 6, 10 )
3 9 =AVERAGE( A1, A2, A3, A4, A5 )
4 6 =AVERAGE( A1:A3, {6, 10} )
5 10
 Results:
A B
1 8 8
2 7 8
3 9 8
4 6 8
5 10

 

Average Function Example-2

Formulas:

Average_formula

Results:

Average_result

 

Average Function Error

The most common error from the Excel Average function is the #DIV/0! error occurs if the values to be averaged are all non-numeric

 

Download Documents

Download Excel File

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment