Countifs formula for tickets created within a month


I have a situation where I am trying to count tickets that were closed within the same month they were opened. I have a status column, a created date (automated from the system) and a completion date. I am using the formula below but the system is giving me a value that I know it is not right. I am thinking I need an "AND" on this formula but I can't seem to make it work.

Any suggestions, I'd greatly appreciate it.

=COUNTIFS({ RAID Log Range 4}, IFERROR(MONTH(@cell), 0) = 9, {RAID Log Range 2}, IFERROR(MONTH(@cell), 0) = 9, {p RAID Log Range 3}, "closed")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!