问题描述
我目前有两列带有日期，我正尝试使用COUNTIFS来检查如果第一个日期大于第二个日期，请向上计数.
I currently have two columns with dates in them, i am trying to use the COUNTIFS to check that if the first date is greater than the second date, count up.
我目前有这个，但它不起作用:
i currently have this but it does not work:
=COUNTIFS('CDT DWGS-2014'!F:F,2014,'CDT DWGS-2014'!S:S,"<>",'CDT DWGS-2014'!Q:Q,">" &'CDT DWGS-2014'!S:S)
我不知道出什么问题了，并且我已经在网上寻找了一段时间，但是我似乎找不到出什么问题了.
I do not know what is wrong and i have been looking on the web for a while now, but i can't seem to find what is wrong.
还有另一种方法可以做到这一点吗?
Is there another way to go about doing this?
谢谢
推荐答案
您无法使用 COUNTIFS 进行一对一"列比较，请尝试使用 SUMPRODUCT 这个
You can't do a "one to one" column comparison with COUNTIFS, try SUMPRODUCT like this
= SUMPRODUCT(('CDT DWGS-2014'！F:F = 2014)*('CDT DWGS-2014'！S:S")*('CDT DWGS-2014'！Q:Q>'CDT DWGS-2014'！S:S))
....但是我建议您使用特定范围而不是整个列，否则会很慢
....but I recommend you use specific ranges rather than whole columns otherwise that will be slow
这篇关于Excel COUNTIFS多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！