Question

excel如何统计满足条件的单元格个数，比如数值在-1到1之间

Answer 1

题目的意思是统计-1到1的个数，即是条件统计，条件统计的函数是countif，它的语法是

=countif（数据区域，统计条件）

这里-1到1不好设定条件可以统计大于-1的个数减去大于1的个数，如下例：

=COUNTIF(D11:D20,">-1")-COUNTIF(D11:D20,">=1")

Answer 2

=offset(表1!$a$1,lookup(1,0/((表1!条件1列=条件1)*(表1!条件2列=条件2)),row(a⑴),提取数值列的列数⑴)如=offset(sheet1!$a$1,lookup(1,0/((sheet1!a2)*(sheet1!b2)),row(a⑴),5⑴)

Answer 3

=sumproduct((A1:A100>-1)*(A1:A100<1))
或
=countif(A1:A100,">-1")-countif(A1:A100,">=1")

Answer 4

=COUNTIF(A1:A100,">-1")-COUNTIF(A1:A100,">=1")

Answer 5

countif函数