COUNTIFS between dates, plus other criteria

I am trying to find out how many NEW projects were added on during certain period. I have a date column and a project type column. Here is my formula:

=COUNTIFS({Project List Range 2}, >=DATE(2020, 5, 1), {Project List Range 2}, <=DATE(2020, 5, 31), {Project List Range 3}, "new")

I got Incorrect Argument Set error. I have no problem if I only run the Date or Project Type. What did I do wrong?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!