How to count projects by status and date range

Hi, I'm trying to count the number projects based 2 criteria: status and date range. Both of criteria are located in separate raw sheet I have been getting #unparseable #invalid operation. Below is sample formula used, basically I'm trying to count projects in year 2020 that have "status" complete:

COUNTIFS({Integration Projects: Raw Data Sheet Range 1}, "Complete" , AND ({Integration 2} >=DATE(2020, 01, 01), <=DATE(2020, 12, 31))).

Can anyone help? Thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!