发布网友
共3个回答
热心网友
不及格的为:=COUNTIF(B2:B5,"<60");大于80分的:=COUNTIF(B2:B5,">=80");介于60、80之间的是:=COUNTIF(B2:B5,">=60")-COUNTIF(B2:B5,"<80")。其中:B2:B5代表的是你要统计的分数的单元格。有什么不会的可以再问我,hi我,或者Q我
热心网友
countif(a1:a100,">80")
countif(a1:a100,">60")-countif(a1:a100,">80")
热心网友
不想答了,每次回答都没有回报。