假设成绩在A列，分别为A1:A100=sumproduct((A1:A100>=60)*(A1:A100<=69))=sumproduct((A1:A100>=70)*(A1:A100<=79))=sumproduct((A1:A100>=80)*(A1:A100<=89))=sumproduct((A1:A100>=90)*(A1:A100<=99))
