假设sheet1的分数在A列,在Sheet2空白单元格输入:=COUNTIF(Sheet1!A:A,">=80")-COUNTIF(Sheet1!A:A,">=90")这是计大于等于80但小于90的分数的个数其他依次类推