COUNTIF between date range and 2 criteria
I am trying to cross reference another sheet to count all of the projects assigned to a specific person in between a certain range, but the # of projects assigned and the person assigned to the project are 2 separate criteria.
For example, I want to know how many "A" projects that Jane completed in the month of January.
I have tried a handful of different formula combinations and I've done some digging through past community questions but I'm not quite sure where to even start from anymore lol.
Does anyone have a solution?
Any and all help is appreciated!
Help Article Resources
Check out the Formula Handbook template!