我有一个COUNTIFS
运行良好的函数,但如果我IF=0
在函数开头添加一个,就会出现错误#NAME?
。我在 Excel 文件的其他单元格中也使用了这种方法;我已验证了拼写和区分大小写的文本。事实上,错误旁边的单元格#NAME?
显示了正确的计数4
。有人知道我为什么会收到错误吗?
这有效:
=IF(COUNTIFS('Full Database'!B:B,C10,'Full Database'!I:I,">01/01/2018",'Full Database'!I:I,"<01/15/2018",'Full Database'!M:M,"Incorporated in Production")=0,””,COUNTIFS('Full Database'!B:B,C10,'Full Database'!I:I,">01/01/2018",'Full Database'!I:I,"<01/15/2018",'Full Database'!M:M,"Incorporated in Production"))
这不会:
=IF(COUNTIFS('Full Database'!B:B,C10,'Full Database'!I:I,">01/16/2018",'Full Database'!I:I,"<01/29/2018",'Full Database'!M:M,"Incorporated in Production")=0,””,COUNTIFS('Full Database'!B:B,C10,'Full Database'!I:I,">01/16/2018",'Full Database'!I:I,"<01/29/2018",'Full Database'!M:M,"Incorporated in Production"))
(是的,日期应该不同)