用EXCEL中的COUNTIF函数计算一列数据中大于0小于0.2的数据，该怎么写该函数？

Question

我的函数是 =COUNTIF(A2:A378,">0"&"<0.2"），但结果显示为0，但是A列里的数据确实包含小于0.2且大于0的数据，求EXCEL达人指点~

Answer 1

=COUNTIF(A2:A378,">0")-COUNTIF(A2:A378,">=0.2"）

Answer 2

07以上版本的是=countifs(A2:A378,">0",A2:A378,"<0.2")

03版本的=sumproduct（（A2:A378>0)*(A2:A378<0.2))

Answer 3

=COUNTIF(A2:A378,">0")-countif(A2:A378,">=0.2")
=countifs(A2:A378,">0",A2:A378,"<0.2")

Answer 4

=countifs(A2:A378,">0",A2:A378,"<0.2")

Answer 5

+COUNTIF(A2:A378,AND(">0","<0.2"))