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
-
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")
Answers
-
Try this...
=COUNTIFS({Access Request Range 5}, AND(@cell >= DATE(2021, 7, 1), @cell <= DATE(2021, 9, 30), {Access Request Range 2}, "Approved")
-
I now have an error for the data type
I'm referencing a separate sheet. Trying to get a count of the statuses marked "Approved" within the 3rd quarter of the year based on their date submitted (7/01/2021 to 9/30/2021)
-
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
Categories
Check out the Formula Handbook template!