Question

如图，在excel中怎么列公式计算有多少笔？

Answer 1

为方便设计公式，重新设置一下表格：

M2公式：

=COUNTIFS(H:H,">"&K2,H:H,"<="&L2)

下拉到M5；

M6公式：

=COUNTIFS(H:H,">"&K5)

Answer 2

第一个 =countif(h:h,"<=10000")
第二个 =countif(h:h,"<=100000")-countif(h:h,"<=10000")
第三个 =countif(h:h,"<=500000")-countif(h:h,"<=100000")
第四个 =countif(h:h,"<=1000000")-countif(h:h,"<=500000")
第五个 =countif(h:h,">1000000")

追问

谢谢

Answer 3

=max(frequency(h$2:h$7%%,{1,10,50,100}))

追问

剩下的是按照这个填充吗？

追答

看错题了。。
直接选择M3:M7的区域，输入函数 =frequency(h$2:h$7%%,{1,10,50,100})
按ctrl+shift+回车

追问

谢谢