总评在90分以上者个数,期末成绩的和,Excel如何计算等级?

2025-03-24 03:22:05
推荐回答(4个)
回答1:

用COUNTIF公式
=COUNTIF(数据区域,">90")

回答2:

=COUNTIF(E:E,">90")
=SUM(C:C)

等级是排序吗?
=RANK(E2,E:E)
下拉填充

回答3:

=COUNTIF(E2:E50,">90")

回答4:

em 没明白,说清楚可行?