Countif using Dates and another Range

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")
Β
Β
Comments
-
You need to use a COUNTIFS instead of a COUNTIF to be able to include additional criteria.
-
Always missing the little things!......That did it!
Thank you very much
-
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.Β
Help Article Resources
Categories
Check out the Formula Handbook template!