# AVERAGE

## 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.