excel表格中一列数字中有正负数之分，有什么函数可以求出这列数字正数所占总数的百分比

Question

所占的总数并不是总数之和，是数量 个数

Answer 1

可以用条件求和函数SUMIF求出正数的和，然后再除以总数
=sumif(a:a,">0",a:a)/sum(a:a)

Answer 2

=countif(a:a,">0")/count(a:a)
设置公式所在单元格格式为百分比本回答被提问者采纳

Answer 3

=SUMIF(A:A,">0")/SUM(A:A)%

Answer 4

=COUNTIF($A$2:$A$7,">0")/COUNT($A$2:$A$7)

Answer 5

=COUNTIF(A1:A20,">=0")/COUNTIF(A1：A20，"<0")