计算区域A1:A9中大于10、小于30的单元格个数,可以使用公式______。
(A)=COUNTIF(A1:A10,">10") - COUNTIF(A1:A10, "30") - COUNTIF(A1:A10, ">=10")
(C)=COUNTIF(A1:A10,">10") - COUNTIF(A1:A10, ">=30")
(D)=COUNTIF(A1:A10,">=30") - COUNTIF(A1:A10, ">10")
参考答案
继续答题:下一题
(A)=COUNTIF(A1:A10,">10") - COUNTIF(A1:A10, "30") - COUNTIF(A1:A10, ">=10")
(C)=COUNTIF(A1:A10,">10") - COUNTIF(A1:A10, ">=30")
(D)=COUNTIF(A1:A10,">=30") - COUNTIF(A1:A10, ">10")