sisalindri

This article describes the formula syntax and usage of the AVERAGEA  function in Microsoft Excel. Description Calculates the average (arithmetic mean) of the values in the list of arguments. Syntax AVERAGEA(value1, [value2], ...) The AVERAGEA function syntax has the following arguments: Value1, value2, ...     Value1 is required, subsequent values are optional. 1 to 255 cells, ranges of cells, or values for which you want the average. Remarks Arguments can be the following: numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference. Logical values and text representations of numb...

When you create an Excel table , Excel assigns a name to the table, and to each column header in the table. When you add formulas to an Excel table, those names can appear automatically as you enter the formula and select the cell references in the table instead of manually entering them. Here's an example of what Excel does: Instead of using explicit cell references Excel uses table and column names =Sum(C2:C7) =SUM(DeptSales[Sales Amount]) That combination of table and column names is called a structured reference. The names in structured references adjust whenever yo...