# Average

### EXCEL Functions: AVERAGE - arithmetic mean

Function AVERAGE(), the English version AVERAGE(), returns the arithmetic average of its arguments. Also discussed the function AVERAGEA(), the English version AVERAGEA()

### EXCEL Functions: AVERAGEIF - arithmetic mean based on multiple conditions

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.

### EXCEL Functions: GEOMEAN - geometric mean of an array of positive data

Function GEOMEAN(), the English version GEOMEAN(), returns the geometric mean of its arguments.

### EXCEL Functions: DAVERAGE - Average values based on multiple conditions

Function DAVERAGE(), the English version of the DAVERAGE(), calculates the average value in the column, but only among the values satisfying the specified conditions.

### Extract unique values from EXCEL Table and Average values in another Column

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.

### Average of last 5 values in a column in EXCEL

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.

### Excel Weighted Average Formula

will Calculate the weighted average price of the commodity without using an auxiliary column.

### Average in EXCEL (with one text criteria)

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.