Countifs formula for tickets created within a month

Jona_g28

Hello,

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")

Paul Newcome

Where are you trying to incorporate the AND function? Are you wanting to include a year argument or is there something else throwing the number off?

Jona_g28

Hi Paul,

For some reason the formula got updated to show the correct count. My logic was working, I just thought I was doing something wrong. Thanks for your help!

Paul Newcome

Excellent. Glad it is working for you now.