Name
AVERAGE
Synopsis
Use AVERAGE to determine the average between multiple numeric values. This average is commonly referred to as the arithmetic mean. For example, if you have the scores 75, 88, 95, and 89 this function would return an average score of 86.75.
To Calculate
=AVEREAGE(Number1
,Number2
, ...)
There must be at least one Number
argument
specified.
Example
Figure 15-1 illustrates how AVERAGE is used to find the average of a list of numeric values. You will notice that the logical value in cell A9 is ignored by this function; whereas, AVERAGEA includes the value in the result.
Note
The AVERAGE function only calculates the average between numeric values. If you have a range that includes text or logical values you should use the AVERAGEA function.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.