Counting Specific Selections within Date Range

Jordan Ionita

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

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