excel 如何设置不计算空格
发布网友
共4个回答
热心网友
把公式中的COUNTA(F19:F33)部分，更改为COUNTIF(F19:F33,">=0")
完整公式：
=IF(COUNTIF(F19:F33,">=0")=SUMPRODUCT((F19:F33>=F16-F18)*(F19:F33<=F16+F17)),"OK","NO")
热心网友
=IF(F19="","",IF(COUNTA(F19:F33)=SUMPRODUCT((F19:F33>=F16-F18)*(F19:F33<=F16+F17)),"OK","NO"))
热心网友
=IF(SUMPRODUCT(((F19:F33<F16-F18)+(F19:F33>F16+F17))*(F19:F33<>"")),"NO","OK")
=IF(COUNTIF(F19:F33,"<"&F16-F18)+COUNTIF(F19:F33,">"&F16+F17),"NO","OK")
热心网友
<>""
