excel利用公式统计60至69分(含60和69)的人数,将数据放入A15单元格...答:A15输入公式 =countif(A1:A14,"<=69")-countif(A1:A14,"<60")或 输入下面的公式后按SHIFT+CTRL+ENTER =SUM(COUNTIF(A1:A14, "<"&{60,70})*{-1,1})例如:如果平均分在D列,那么输入=COUNTIF(D:D,">=60")-COUNTIF(D:D,">69")或者 =COUNTIFS(D:D,">=60",D:D,"<=69")...