CODEWITHSUNDEEP
excelexcel-formulaexcel-2010countif
HumanlyRespectable
HumanlyRespectable

Reputation: 203

Excel COUNTIFS Multiple Columns

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

Upvotes: 0

Views: 1073

Answers (1)

barry houdini
barry houdini

Reputation: 46361

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

Upvotes: 3

Related Questions