**Rational**

Find the average of numbers

**Description**

The Excel AVERAGE function returns an average of numbers positioned in one or multiple ranges.

For example, suppose that a list of digits is in a column and user want to find the average of numerical values, the formula can be **=AVERAGE(5,15,30)** the Excel add all three numbers and divide by 3, and returns **16.67**.

**Syntax**

= AVERAGE(number1, [number2], …)

**Parameters**

**number1** – First cell reference, or range of numerical values**number2** [optional] – Second cell reference, or range of numerical values. The AVERAGE function can accommodate up to 255 numbers as an argument.

**Return Value**

Average of numbers.

**Key Notes**

- The AVERAGE function calculates the average (arithmetic mean) of numbers in the arguments.
- Use AVERAGEIF and AVERAGEIFS to calculate the average for the cells specified by one or multiple conditions.
- Arguments can be supplied as numbers, ranges, named ranges, or cell references that contain a numerical value.
- Function ignore empty or blank cell

**Example**

To get average where one column is blank like here =AVERAGE(B7:D7) it return 17.5 as excluding blank cell.

## Keep Reading Similar Functions:

### SUM

The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.

### AVERAGEIF

The AVERAGEIF function returns an average figure based on given criteria like =AVERAGEIF({6;8;10;3;5},”>5″) average numbers that are more than 5 and return 8.

### AVERAGEIFS

The AVERAGEIFS function returns an average number based on one or multiple given criteria, sum adjacent cells that meet given conditions.