Excel表里求平均数的函数是“AVERAGE”。
具体用法如下:
一、首先打开一张表格,光标定位需要得到求平均数结果的单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fc1f4134970a304e6106f3f4ddc8a786c9175c93?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、在菜单里选择“插入”--->“函数”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e1fe9925bc315c601d2f38e181b1cb1349547701?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、选择求平均函数AVERAGE。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8d5494eef01f3a2909f286c09525bc315c607c81?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
四、输入需要求平均数的参数,本文例子明显可知,A2、B2、C2。当输入三个参数完毕时,在平均函数编辑框,就能看到计算的结果。而单元格D2里显示的求平均函数公式为AVERAGE(A2,B2,C2),此条公式适用于非连续数据区域的求平均数操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ac4bd11373f0820227f8c23147fbfbedab641b51?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f7246b600c33874433b87c725d0fd9f9d72aa0bb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
五、确定平均函数编辑完毕后,在表格中按回车,可看到正确的计算结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e7cd7b899e510fb37aee2799d533c895d0430ccc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)