Excel COUNTIFS多列 [英] Excel COUNTIFS Multiple Columns

问题描述

我目前有两列带有日期，我正尝试使用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多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！