标签归档:excel

这几天用到得excel公式

Published / by whosb / Leave a Comment
=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
统计某个表中某一数字出现的百分比