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.
Average of numbers.
- 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.