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.