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))右拉再下拉公式。 如图:示例
有一列学生成绩数据,在excel里如何设置公式,求在80-95分区间的有...答:=COUNTIFS(C2:C20,">80",C2:C20,"<=95") ——个数 =SUMIFS(C2:C20,C2:C20,">80",C2:C20,"<=95")/COUNTIFS(C2:C20,">80",C2:C20,"<=95")——均值 小于60分的:=COUNTIFS(C2:C20,"<60") ——个数 =SUMIFS(C2:C20,C2:C20,"<60")/COUNTIFS(C2:C20,"<60")——均值 ...