excel求平均值如何让零值不计算在内https://zhidao.baidu.com/usercenter?uid=8dd2406923
6f25705e79101d再见0559|浏览4275次|举报http://www.baidu.com/s?wd=ex
cel%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E5%A6%82%E4%BD%95%E8%AE%A
9%E9%9B%B6%E5%80%BC%E4%B8%8D%E8%AE%A1%E7%AE%97%E5%9C%A8%E5%86%85&
ie=utf-82014-08-21最佳答案以a1:a7为一个区域，其中含有一个0值，求平均值输入公式：=SUM(A1:A7)
/COUNTIFS(A1:A7,"<>0")，已验证本回答由提问者推荐举报|答案纠错|评论86https://zhid
ao.baidu.com/usercenter?uid=0e084069236f25705e79ac4akathy_cz04采纳
率：54%来自团队：https://zhidao.baidu.com/uteam/view?fr=qb&teamId=48285
Excel之家擅长：https://zhidao.baidu.com/browse/864办公软件其他回答https://
zhidao.baidu.com/question/1430634256781732179.htmlhttps://zhidao.
baidu.com/question/1430634256781732179.htmlhttps://www.baidu.com/
s?ie=utf-8&f=8&rsv_bp=1&rsv_idx=1&tn=sitehao123_15&wd=%E9%99%A4%E
9%9B%B6%E5%80%BC%E5%B9%B3%E5%9D%87%E5%80%BC&oq=%25E9%2599%25A4%25
E9%259B%25B6%25E5%2580%25BC&rsv_pq=a37a128d000343bf&rsv_t=04darPB
61ZjPDI35S9o9YucCNUBVuLyJkOZSa4BsdukixZIE%2Fu%2FpMF49C7cqBcGKXKC%
2BwQ&rqlang=cn&rsv_enter=1&bs=%E9%99%A4%E9%9B%B6%E5%80%BC=AVERAGE
IF(A1:A8,"<>0",A1:A8)这个最灵,这个才是标准答案好么.https://zhidao.baidu.com/us
ercenter?uid=3d0f4069236f25705e79320abeatle1981|发布于2014-08-21举
报|评论(4)232用http://www.baidu.com/s?wd=SUM%E5%87%BD%E6%95%B0&tn
=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y3Ph7BnW64uWTL
rAu-uWcz0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQ
LGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnHf1njm1PjcdPWT3nHT1nWDLrfSUM函
数加http://www.baidu.com/s?wd=COUNTIF%E5%87%BD%E6%95%B0&tn=44039180
_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y3Ph7BnW64uWTLrAu-uWcz0
ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz
4Bmy-bIi4WUvYETgN-TLwGUv3EnHf1njm1PjcdPWT3nHT1nWDLrfCOUNTIF函数 |
|
