COUNTIFS between dates & criteria.


Greetings Smartsheet Community,    smiley

I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame


So far I am successful counting the dates in the range using the following formula:

=COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1))


Next I'd like to add "AND" and "OR" ( to count all tasks "Completed") but I keep running into errors. 


Does anyone have a solution?

Any advice would be greatly appreciated.


Thank you!





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!