Counting Specific Selections within Date Range

Hi,

I am trying to count how many times a combination is selected within each month. For example, how many times does this combination pop up in the month of March

I am currently playing with this formula, but keep getting error messages

=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, AND(HAS(@cell, "FMLA") HAS(@cell, "CFRA"), {LOA Tracker Range 3}, AND(@cell>=DATE(2021, 3, 1), @cell<= DATE(2021, 3, 31))))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Your above formula only has a single misplaced closing parenthesis. You forgot to close out the AND statement after the second HAS which in turn automatically added that missing closing parenthesis to the end. Moving that to where it should be should clear things up for you.

=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, AND(HAS(@cell, "FMLA") HAS(@cell, "CFRA")), {LOA Tracker Range 3}, AND(@cell>=DATE(2021, 3, 1), @cell<= DATE(2021, 3, 31)))

Jordan Ionita

Hi Paul,

I am still getting the "unparseable" error message when I copy your formula.

Paul Newcome

Are you able to provide a screenshot of the formula in the sheet similar to the screenshot below?

Jordan Ionita

Paul Newcome

My apologies. In the post with your original formula, the HAS functions are split by the new row, and I missed that there isn't a comma between them.

=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, AND(HAS(@cell, "FMLA"), HAS(@cell, "CFRA")), {LOA Tracker Range 3}, AND(@cell>=DATE(2021, 3, 1), @cell<= DATE(2021, 3, 31)))

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.