怎么用公式把总成绩每个分数段的人数统计到第二个表啊,要用公式

发布网友发布时间：2024-10-04 21:34

共2个回答

热心网友时间：2024-10-05 01:25

假定总成绩在f4:f9
100-90 =countif(f4:f9,">=90")
89-80 =countif(f4:f9,">=80")-countif(f4:f9,">=90")
79-70 =countif(f4:f9,">=70")-countif(f4:f9,">=80")
69-60 =countif(f4:f9,">=60")-countif(f4:f9,">=70")
不及格 =countif(f4:f9,"<60")

热心网友时间：2024-10-05 01:26

=sumproct((E3:E8>=90)*(E3:E8<=100))
=sumproct((E3:E8>=80)*(E3:E8<=89))
=sumproct((E3:E8>=70)*(E3:E8<=79))
=sumproct((E3:E8>=60)*(E3:E8<=69))
=countif(E3:E8,"<60")

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com