COUNTIF(S) to sum number of issues completed in a given range
Looking to create a sheet summary and need a formula that will return the number of items with a creation date between 05/01/2022 - 05/31/2022 that also have the build status marked as "Complete" or "Delivered".
Tried these two formulas, both return as "unparseable"
=COUNTIFS(MONTH([Complete Date]5), [Build Status]:[Build Status], "Complete"])
=COUNTIFS([Created Date]:[Created Date], AND(IFERROR(YEAR(@cell), 0) = 2022, IFERROR(MONTH(@cell), 0) = 5), Build Status:Build Status, @cell = "Complete")
Help Article Resources
Check out the Formula Handbook template!