求大侠帮助!excel 一列中比某一值大的数有几个!怎么弄啊~~

2024-12-01 23:09:33
推荐回答(4个)
回答1:

查找A1:A9中比26大的数,公式是:=COUNTIF(A1:A9,">26")

回答2:

假设数据在A列
=COUNTIF(A:A,">26")

回答3:

=countif(A:A,">26")

回答4:

=countif(a:a,">26")