EXCEL中求平均值的方法:
EXCEL中求平均值可直接用平均值函数AVERAGE,如图,公式为:=AVERAGE(A1:F1),此函数是跳过空单元和文本的,图中事实上是求4个数的均值;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cc11728b4710b912f878515ac5fdfc03934522dc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
但有时,算均值时,对于空单元要按0算,即空单元也要参与基数运算,一种方法就是补0,即没有数量的全部填上0;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c8177f3e6709c93d5509a853993df8dcd000549e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
但上面的方法影响视觉效果,往往在填表时,没有数量的都是空着,此时求均值就不能直接用平均值函数来求,而要总量和除以基数的方法来做:=SUM(A1:F1)/COLUMNS(A1:F1),COLUMNS是返回列数函数,不用直接去数有几个。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/86d6277f9e2f070855b98aa4ef24b899a801f2d2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)