假设是A1至A100单元格的数字求平均值
则公式为
=SUM(A1:A100)/COUNTIF(A1:A100,">0")
沉音另汉尔位末却等其落如果数据中还有小于0的值也要参与计算,则公式改为
=SUM(A1:A100)/(COUNTIF(A1:A100,">0")+COUNTIF(A1:A100,"<0"))
标签：exc,山定,独兴书
版权声明：文章由 知识百答 整理收集，来源于互联网或者用户投稿，如有侵权，请联系我们，我们会立即处理。如转载请保留本文链接：https://www.zhshbaida.com/answer/27469.html
