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!

 

Josh

«1345

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!