Countif using Dates and another Range

Phil B.

I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT   reply. Not sure what is wrong. Below is a copy of my Formula.

 

=COUNTIF([Request Create Date]:[Request Create Date], >=DATE(2018, 1, 1), [Issue/Nonconformance]:[Issue/Nonconformance], "Install Vendor Workmanship")

 

 

Paul Newcome

You need to use a COUNTIFS instead of a COUNTIF to be able to include additional criteria.

Phil B.

Always missing the little things!......That did it!

Thank you very much

Paul Newcome

I kept doing the same thing. That's why I switched to using only COUNTIFS. You can use it with one set of criteria or multiple, and you don't have to forget to add that "S". Hahaha

 

Happy to help.