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


Find the average of numbers


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.


= AVERAGE(number1, [number2], …)


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


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 a cell range based on multiple criteria in Excel


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

Read More »
Find the average of numbers in Excel


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


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 »