Microsoft Excel Functions & Formulas

Use the AVERAGE function to calculate the

average output

In this example, the output of three production lines has been

recorded for several days. Now the average of the three highest

outputs of each line has to be calculated. For this task, Excel pro-

vides the AVERAGE function, which returns the average, or

arithmetic mean, of the arguments.

AVERAGE(number1, number2, ...)

number1, number2, ...: From 1 to 30 numeric arguments for

which you want to determine the average. It is also possible to

use a cell reference, as shown in this example.

4

To calculate the average of the three highest capacities of

each production line:

1. In cells B2:D10 type the output ...