17e0b3236aff936.jpg如图所示，要统计A列中大于C2单元格数值的单元格个数，下列公式选项正确的是（）。
A: =COUNTIF(A2:A10,>;C2)
B: =COUNTIF(A2:A10,">;C2")
C: =COUNTIF(A2:A10,">;"C2)
D: =COUNTIF(A2:A10,">;"&C2)
A: =COUNTIF(A2:A10,>;C2)
B: =COUNTIF(A2:A10,">;C2")
C: =COUNTIF(A2:A10,">;"C2)
D: =COUNTIF(A2:A10,">;"&C2)
举一反三
- 计算区域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")
- Excel2010中,计算单元格区域A1:A9中大于10(包含10)、小于30(不包含30)的单元格个数,使用的公式是()。 A: =COUNTIF(A1:A10,">30")-COUNTIF(A1:A10,">=10") B: =COUNTIF(A1:A10,">=10")-COUNTIF(A1:A10,">=30") C: =COUNTIF(A1:A10,">10")-COUNTIF(A1:A10,"<30") D: =COUNTIF(A1:A10,">=30")-COUNTIF(A1:A10,">10")
- 17e0c8854182f22.jpg如图所示，统计A列中大于54的单元格个数，下列选项中正确的是（）。 A: =COUNTIF(A2:A10,">;54") B: =COUNTIFS(A2:A10,">;"&54) C: =COUNTIFS(A2:A10,">;54") D: =COUNTIFS(A2:A10,">;"&"54")
- 下列函数格式正确的是（ ） A: =IF(A2>;60,"及格","不及格") B: =COUNTIF(">;60",A2:A10) C: IF(A2>;60,"及格","不及格") D: COUNTIF(">;60",A2:A10)
- 中国大学MOOC: 单元格A1,A2,B1,B2,C1,C2分别为1、2、2、3、3、3，公式 SUM(a1:c2)= 。