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:
AVERAGEIFS
The AVERAGEIFS function returns an average number based on one or multiple given criteria, sum adjacent cells that meet given conditions.
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.
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.
