# Excel AVERAGE Function

The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.

**number1**- A number or cell reference that refers to numeric values.**number2**- [optional] A number or cell reference that refers to numeric values.

The AVERAGE function calculates the average of numbers provided as arguments. To calculate the average, Excel sums all numeric values and divides by the count of numeric values. This behavior can be replicated with the SUM and COUNT functions like this:

AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.

The AVERAGE function *automatically* ignores text values and empty cells. However, zero (0) values are included. You can ignore zero (0) values and/or apply specific criteria using the AVERAGEIFS function, as explained below.

The AVERAGE function will ignore logical values and numbers entered as text. If you need to include these values in the average, see the AVERAGEA function.

If the values given to AVERAGE contain errors, AVERAGE returns an error. You can use the AGGREGATE function to ignore errors.

### Basic usage

A typical way to use the AVERAGE function is to provide a range, as seen below. The formula in F3, copied down, is:

=AVERAGE(C3:E3)

At each new row, AVERAGE calculates an average of the quiz scores for each person.` `

### Blank cells

The AVERAGE function automatically ignores blank cells. In the screen below, notice cell C4 is empty, and AVERAGE simply ignores it and computes an average with B4 and D4 only:

However, note the zero (0) value in C5 *is included* in the average, since it is a valid numeric value. To exclude zero values, use AVERAGEIF or AVERAGEIFS instead. In the example below, AVERAGEIF is used to exclude zero values. Like the AVERAGE function, AVERAGEIF *automatically excludes* empty cells.

=AVERAGEIF(B3:D3,">0") // exclude zero

### Mixed arguments

The numbers provided to AVERAGE can be a mix of references and constants:

=AVERAGE(A1,A2,4) // returns 3

### Average with criteria

To calculate an average with criteria, use AVERAGEIF or AVERAGEIFS. In the example below, AVERAGEIFS is used to calculate the average score for Red and Blue groups:

=AVERAGEIFS(C5:C14,D5:D14,"red") // red average =AVERAGEIFS(C5:C14,D5:D14,"blue") // blue average

The AVERAGEIFS function can also apply multiple criteria.

### Average top 3

By combining the AVERAGE function with the LARGE function, you can calculate an average of top n values. In the example below, the formula in column I computes an average of the top 3 quiz scores in each row:

### Weighted average

To calculate a *weighted* average, you'll want to use the SUMPRODUCT function, as shown below:

Read a complete explanation here.

### Notes

- AVERAGE automatically ignores empty cells and cells with text values.
- AVERAGE includes zero values. Use AVERAGEIF or AVERAGEIFS to ignore zero values.
- Arguments can be supplied as constants, ranges, named ranges, or cell references.
- AVERAGE can handle up to 255 total arguments.
- To see a quick average
*without a formula*, you can use the status bar.

## Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.