计算区域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")
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")
- Excel2010中,计算单元格区域A1:A10中大于10(包含10)、小于30(不包含30)的单元格个数,使用的公式是
- 在单元格中输入“=SUM($A$1:$A$10)”或“=SUM(A1:A10)”,结果一样
- 在Excel2010中,要统计A1:C5单元格区域中数值大于等于30的单元格个数,应该使用的公式是()。 A: =COUNTIF(A1:C5,">=30") B: =COUNTIF(A1:C5,>=30) C: =COUNTIF(A1:C5,">30") D: =COUNTIF(A1:C5,>="30")
- 在Excel工作表的A1:A10单元格中分别输入10个数1~10,在B1单元格中输入=A1^2,这个公式复制到B2:B10单元格,在B10单元格中公式的形式为______ A: =A1^2 B: =A10^2 C: =$A$1^2 D: =$AS10^2