求A1:O3区域中所有正数的平均值：=AVERAGE(IF(A1:O3>0,A1:O3))求A1:O3区域中所有负数的平均值：=AVERAGE(IF(A1:O3<0,A1:O3))输入结束后按组合键确认。
2007 以上好像有 averageif(a1:z10,">0")通用：sumif(a1:z10,">0")/countif(a1:z10,">0")
