excel销售达标率怎么计算

若每个数据分别在a列的不同单元格，则大于0.39小于0.46=text(SUMPRODUCT((A1:A100>0.39)*(A1:A100<0.46))/count(a:a）,"0.00%")其他类推若是两个范围加在一起算达标率则=TEXT(SUMPRODUCT(((A1:A100>0.39)*(A1:A100<0.46)+(A1:A100>1.29)*(A1:A100<1.36)))/COUNT(A:A),"0.00%")