Difference between revisions of "Manuals/calci/AVERAGEA"
Jump to navigation
Jump to search
| Line 51: | Line 51: | ||
|} | |} | ||
| − | =AVERAGEA(A1:A4) : Calculates the average of numbers in the range A1 to A4. Returns '''12.5''' as a result. | + | =AVERAGEA(A1:A4) : Calculates the average of numbers in the range A1 to A4. <br />Returns '''12.5''' as a result. |
| − | =AVERAGEA(A1:A5) : Calculates the average of numbers in the range A1 to A5. Text 'Data' is evaluated as 0. Returns '''10''' as a result. | + | =AVERAGEA(A1:A5) : Calculates the average of numbers in the range A1 to A5. Text 'Data' is evaluated as 0. <br />Returns '''10''' as a result. |
| − | =AVERAGEA(A1:A6) : Calculates the average of numbers in the range A1 to A6. Empty cell is ignored. Returns '''10''' as a result. | + | =AVERAGEA(A1:A6) : Calculates the average of numbers in the range A1 to A6. Empty cell is ignored. <br />Returns '''10''' as a result. |
| − | =AVERAGEA(4,6,"TRUE") : Calculates the average of numbers and logical value TRUE (1). Returns '''3.3333333333333335''' as a result. | + | =AVERAGEA(4,6,"TRUE") : Calculates the average of numbers and logical value TRUE (1). <br />Returns '''3.3333333333333335''' as a result. |
==See Also== | ==See Also== | ||
Revision as of 16:40, 20 February 2014
AVERAGEA(n1, n2, .....)
- where are values or range of cells containing values.
are values or range of cells containing values.AVERAGEA() calculates the average (arithmetic mean) of the mentioned values.
Description
AVERAGEA(n1, n2, .....)
- Arithmetic mean is the sum of values divided by the number of values.
- Argument can be numbers, names, arrays, or range of cells containing numbers, logical values etc.
- If logical values and text representation of numbers is entered directly as a part of argument, it is counted.
- Logical value TRUE is evaluated as 1 and logical value FALSE is evaluated as 0.
- Empty text ("") is ignored. Cells containing text are evaluated as 0.
- For invalid argument values, Calci displays error message.
- AVERAGE() function can be used if arguments do not contain text or logical values.
Examples
| 20 | |
| 15 | |
| 5 | |
| 10 | |
| Data | |
=AVERAGEA(A1:A4) : Calculates the average of numbers in the range A1 to A4.
Returns 12.5 as a result. =AVERAGEA(A1:A5) : Calculates the average of numbers in the range A1 to A5. Text 'Data' is evaluated as 0.
Returns 10 as a result. =AVERAGEA(A1:A6) : Calculates the average of numbers in the range A1 to A6. Empty cell is ignored.
Returns 10 as a result. =AVERAGEA(4,6,"TRUE") : Calculates the average of numbers and logical value TRUE (1).
Returns 3.3333333333333335 as a result.