How to calculate the average output using the AVERAGE function
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 provides the AVERAGE function, which returns the average, or arithmetic mean, of the arguments. Here is the syntax that is used:
AVERAGE(number1, [...]
