Returns the average (arithmetic mean) of all the numbers in a column.
|Sr.No.||Parameter & Description|
The column that contains the numbers for which you want the average.
Returns a decimal number that represents the arithmetic mean of the numbers in the column.
If the column contains logical values or empty cells, those values are ignored and the rows are not counted.
Cells with the value zero are included and the rows are counted for the divisor.
Whenever there are no rows to aggregate, the function returns a blank. However, if there are rows, but none of them meet the specified criteria, the function returns 0.
= AVERAGE (Sales[Sales Amount])
26 Lectures 4.5 hours