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

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

• Hi Paul,

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

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

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!