Countifs formula for tickets created within a month

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

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.