这几天用到得excel公式

=countif($b1:$b44444,”=1″)
=countif($b1:$b44444,”<=10″)
=countif($b1:$b44444,”<=50″)-countif($b1:$b35838,”<=10″)
=countif($b1:$b44444,”<=100″)-countif($b1:$b35838,”<=50″)
=countif($b1:$b44444,”>100″)
统计出现次数的

=(COUNTIF(‘20100415’!$a$1:$b$35838,A2))/35838
=(COUNTIF(‘20100415’!$a$1:$b$35838,”<=50″)-COUNTIF(‘20100415’!$a$1:$b$35838,”<=25″))/35838
=(COUNTIF(‘20100415’!$a$1:$b$35838,”<=100″)-COUNTIF(‘20100415’!$a$1:$b$35838,”<=50″))/35838
=(COUNTIF(‘20100415’!$a$1:$b$35838,”>100″))/35838
统计某个表中某一数字出现的百分比

 


评论

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据