excel中如何統計分數段人數

期末考試成績最近會出來了，各位老師需要對自己班上各個分段數學生數量有所瞭解，今天為大家介紹一種簡便有效的統計方法。

方法

假設一組數據。

更具自己需要，設置分段數。

在C2框內輸入

=COUNTIF($A$2:$A$10,">=0")-COUNTIF($A$2:$A$10,">60")

在C3單元格內輸入

=COUNTIF($A$2:$A$10,">=60")-COUNTIF($A$2:$A$10,">70")

在C4單元格內輸入

=COUNTIF($A$2:$A$10,">=70")-COUNTIF($A$2:$A$10,">80")

在C5單元格內輸入
=COUNTIF($A$2:$A$10,">=80")-COUNTIF($A$2:$A$10,">90")

在C6單元格內輸入

=COUNTIF($A$2:$A$10,">=90")-COUNTIF($A$2:$A$10,">=100")

分數段統計就完成啦！