Function AVERAGE(), the English version AVERAGE(), returns the arithmetic average of its arguments. Also discussed the function AVERAGEA(), the English version AVERAGEA()
Find the average of all cells whose values match a certain criterion. For this purpose, there is a simple and effective function AVERAGEIF(), the English version AVERAGEIF(), which first appeared in EXCEL 2007.
Function GEOMEAN(), the English version GEOMEAN(), returns the geometric mean of its arguments.
Function DAVERAGE(), the English version of the DAVERAGE(), calculates the average value in the column, but only among the values satisfying the specified conditions.
you Have a table consisting of two columns: a column of duplicate text values and column numbers. We will create a table consisting only of lines with unique text values. By the numeric column will produce a calculation of the average.
Find the average of the last 5 last values in the list. If the column values are constantly filled, this task is no longer trivial.
will Calculate the weighted average price of the commodity without using an auxiliary column.
Find the average of all cells whose values meet a specific condition. For this purpose in MS EXCEL there is a simple and effective function AVERAGEIF(), which first appeared in EXCEL 2007. Consider the case when the criterion is applied the range containing text values.