excel表格用函数求平均分>=80的人所例占的比 - 知识问答

=80")/COUNTIF(c2:c500,">=0")或者=COUNTIF(c2:c500,">=80")/C" property="og:description"/> excel表格用函数求平均分>=80的人所例占的比 - 知识问答 =80")/COUNTIF(c2:c500,">=0")或者=COUNTIF(c2:c500,">=80")/C"/>

excel表格用函数求平均分>=80的人所例占的比例

1个回答

=COUNTIF(c2:c500,">=80")/COUNTIF(c2:c500,">=0")
或者
=COUNTIF(c2:c500,">=80")/COUNT(c2:c500)
假设C列为平均成绩

相关问题