方法一 =COUNTIFS(A1:A8,">=90",A1:A8,"<=100") 统计A1至A8单元格“>=90且<=100”的单元格数量 方法二 =COUNTIF(A1:A8,">=90")-COUNTIF(A1:A8,">100") 统计A1至A8单元格“>=90且<=100”的单元格数量