如何指定Excel Countifs功能的条件？
我要做的是计算名为“报告截止日期”的Excel列中的值数量，但也没有值（空白）或在名为“ NOT”的值“ N/A”的另一列中名为“日期报告”发出的“
我不熟悉如何指定Countifs功能的条件，但我也不知道是否有更好的方法可以做到这一点，而不是使用Countifs
这就是我所拥有的
=COUNTIFS(Table22[Report Deadline],">=" & TODAY(),Table22[Date Report Issued],"=" "",Table22[Date Report Issued],"=" "N/A")
What I am trying to do is count the number of values in an excel column named "Report Deadline" that are after today, but also have no value(blank) or have the value "N/A" in another column named "Date Report Issued"
I am unfamiliar with how to specify conditions for the COUNTIFS function but I also don't know if there is a better way to do it rather than use COUNTIFS
This is what I have
=COUNTIFS(Table22[Report Deadline],">=" & TODAY(),Table22[Date Report Issued],"=" "",Table22[Date Report Issued],"=" "N/A")
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您在
Countifs中实际上无法真正具有“或”条件。我建议做两个单独的
countifs，然后将它们添加在一起。像这样：如果您真的想在单个表达式中执行此操作，则可以将“ n/a”和“”放入数组中，然后将
countifs包装在sum中。但这本质上是与两个单独的功能一样的事情，并且可以说并不容易阅读：You can't really have an "OR" condition in a
COUNTIFS.I would suggest doing two separate
COUNTIFS, and then adding them together. Like so:If you really wanted to do it in a single expression, you could put "N/A" and "" into an array and wrap the
COUNTIFSin aSUM. But it would essentially be doing the same thing as the two separate functions and arguably not be as easy to read: