I'm trying to find the number of cells that meet a criterion within a specific date window.

=COUNTIFS({Access Request Range 5},>=(2021, 7,1),{Access Request Range 5}, <=(2021,9,30), {Access Request Range 2},"Approved")

Best Answer

  • Maxwony
    Answer ✓

    I found it. there was a ")" missing.

    =COUNTIFS({Access Request Range 5}, AND(@cell >= DATE(2021, 7, 1), @cell <= DATE(2021, 9, 30)), {Access Request Range 2}, "Approved")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!