假如数据在B2至B500是成绩,统计数在C2开始100的人数C2=COUNTIF(B2:B500,"=100")90——99的人数C3=COUNTIF(B2:B500,">=90")-C280—89有多少人C4=COUNTIF(B2:B500,">=80")-C2-C370——79的人数C5=COUNTIF(B2:B500,">=70")-C2-C3-C460—69的人数C6=COUNTIF(B2:B500,">=60")-C2-C3-C4-C550—59的人数C7=COUNTIF(B2:B500,">=50")")-C2-C3-C4-C5-C640—49的人数C8=COU
|