COUNTIF between date range and 2 criteria

aecross ✭✭
edited 08/08/22 in Formulas and Functions

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!

Thank you!!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!