如何计算EXCEL中求分段人数利用公式。求60-69;70-79……,<60,和90>...答:在F3中输入公式:=IF(e3<60,"不及格",IF(AND(e3>=60,e3<=70),"差",IF(AND(e3>=70,e3<=80),"中",IF(e3<=90,"优","良")))再统计优、良、中、差、不及格的数量就行了
EXCEL如何按类别,再按数据区间,分别统计出现的个数?答:E2单元格公式=COUNTIFS($A$2:$A$15,">="&LEFT($D2,FIND("~",$D2)-1)*1,$A$2:$A$15,"<"&RIGHT($D2,LEN($D2)-FIND("~",$D2))*1,$B$2:$B$15,LEFT(E$1))右拉再下拉公式。 如图:示例