Countifs with date criteria and also parsing drop down

Hi all,

Been struggling on a formula for too long. Need some assistance from some of the great minds.

I have taking information from a sheet and trying to count the amount of times a condition is met within a specific time frame.

Here is my current formula:

=COUNTIFS({IC Issue Tracker Range 7}, @cell >= DATE(2023, 2, 20), {IC Issue Tracker Range 7}, @cell <= DATE(2023, 2, 26), {IC Issue Tracker Range 2}, HAS({IC Issue Tracker Range 2}, "Customer Care Approval"))

Range 7: Has the date stamps

Range 2: Has the criteria I am trying to count although I need to specify that it is a dropdown so 1 cell can have multiple selections.

Any help would be greatly appreciated.

Find more posts tagged with

Formulas

Accepted answers

sharkasits

@Ben77 You were really close to getting it 🙂

=COUNTIFS({IC Issue Tracker Range 7}, >= DATE(2023, 2, 20), {IC Issue Tracker Range 7}, <= DATE(2023, 2, 26), {IC Issue Tracker Range 2}, HAS(@cell, "Customer Care Approval"))

Let me know if that doesn't work as intended.

All comments

sharkasits

@Ben77 You were really close to getting it 🙂

=COUNTIFS({IC Issue Tracker Range 7}, >= DATE(2023, 2, 20), {IC Issue Tracker Range 7}, <= DATE(2023, 2, 26), {IC Issue Tracker Range 2}, HAS(@cell, "Customer Care Approval"))

Let me know if that doesn't work as intended.

Ben77

Yes it worked. Thanks, much appreciated!!!!

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.