Counting Specific Selections within Date Range


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!