Computer average function formula

Computer average function formula

Function name：AVERAGE

Main functions: Find the arithmetic mean of all parameters.

Usage format: AVERAGE(number1,number2,……)

Parameter description: number1,number2,……: average value is required The value or reference cell (range), the number of parameters does not exceed 30.

Application example: Enter the formula in cell B8: =AVERAGE(B7:D7,F7:H7,7,8). After confirmation, you can find the area from B7 to D7 , the value in the area from F7 to H7 and the average value of 7 and 8. ​

Special reminder: If the reference range contains "0" value cells, they will be counted; if the reference range contains blank or character cells, they will not be counted.

Recommended tutorial: excel tutorial

The above is the detailed content of Computer average function formula. For more information, please follow other related articles on the PHP Chinese website!