Excel COUNTIFS Multiple Columns

0
votes

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?

Thank you

1
excelexcel-formulaexcel-2010countif
what, exactly, are you trying to achieve? if you're only looking at the first date and comparing it to the second date, you don't need countifs. you just need a simple if: if(firstDate > secondDate, 1, 0) - acushner

1 Answers

3
votes

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