Using Countifs with Date Range and multiple qualifier

I"m trying to create a formula, referencing another sheet, with qualifier of date range, and 'Status' being 'Live' OR 'Ended'.

I have this:

=COUNTIFS({Test Start Date}, <=DATE(2020, 1, 31), {Test Start Date}, >=DATE(2020, 1, 1), {Status}, "Live", {Status}, "Ended")

returning #INVALID REF



Best Answer


  • Thank you Brian W. Much appreciated

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!