[已解决]菜鸟求助：如何在统计百分比时能统计有内容的单元格，见附件

hongqiqqq

再试试这样的

1. =IF(COUNTA(F6:O23)=0,"",IF(COUNTIF(P6:P23,"<>")=0,"",CONCATENATE("共查",COUNTIF(F6:O23,"<>"),"点，其中有“好”占",ROUND((COUNTIF(P6:P23,"好"))/SUM(--(LEN(P6:P23)>0)),4)*100,"%，“一般”占",ROUND(COUNTIF(P6:P23,"一般")/SUM(--(LEN(P6:P23)>0)),4)*100,"%，“差”占",ROUND(COUNTIF(P6:P23,"差")/SUM(--(LEN(P6:P23)>0)),4)*100,"%。")))

复制代码