Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

AVERAGE

Find the average of numbers in Excel
Returns the average of its arguments

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:

Find the average of numbers in Excel

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.

Read More »
To add multiple numbers in Excel

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.

Read More »
Find the average of a cell range based on multiple criteria in Excel

AVERAGEIFS

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

Read More »