如何在Excel的成绩表中找出80至90分的有几人

方法较多，举例如下， =COUNTIFS($B$1:$B$6,">=80",$B$1:$B$6,"<=90") =COUNTIF($B$1:$B$6,">=80")-COUNTIF($B$1:$B$6,">90") =SUM(IF(($B$1:$B$6>=80)*($B$1:$B$6<90),1,0)) =FREQUENCY($B$1:$B$6,90.0001)-FREQUENCY($B