excel中怎么运用countif函数来计算两个数值之间数的个数

2024-11-16 04:21:19
推荐回答(1个)
回答1:

这两个公式都是有效的
=countif(c2:c18,">=5")-countif(c2:c18,">10")
=countif(c2:c18,"<=10")-countif(c2:c18,"<5")