• 2022-10-30
    计算区域A1:A9中大于10、小于30的单元格个数,可以使用公式______。
    A: =COUNTIF(A1:A10, ">=30") - COUNTIF(A1:A10, ">10")
    B: =COUNTIF(A1:A10, ">10") - COUNTIF(A1:A10, "
    C: =COUNTIF(A1:A10, ">30") - COUNTIF(A1:A10, ">=10")
    D: =COUNTIF(A1:A10, ">10") - COUNTIF(A1:A10, ">=30")