我想在A1里统计出A2~A101里大于2且小于88的数值有多少个
请问应该怎么定函数啊？
B2～B101写公式，例如B2的公式是扮运:
=IF(AND(A2>蔽缺改2,A2<宏判88),1,0)
拖动填充B列其它行即可
现在SUM(B2:B101)就是你的结果。
=SUMPRODUCT((19990101<=A2:A101)*(A2:A101<=19991231)*(B2:B101="男"))
=COUNTIF(A2:A101,"<88")-COUNTIF(A2:A101,"<=2")
在A1输入
=COUNTIF(A2:A101,">2")-COUNTIF(A2:A101,">=88")
A1输入
=sumproduct((A2:A101>2)*(A2:A101<88))