如题所述
方法较多,举例如下,
=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$1:$B$6,79.9999)
VBA代码