Nested Criteria

Admin

I am trying to count all "Implemented" and "To Implement" instances in "CS Status" drop down for the current month and year ("Created Date"). I keep getting nested criteria error. I am sure I have put too much information in but can someone help please?

=COUNTIFS([Created Date]:[Created Date], AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) + COUNTIFS([CS Status]:[CS Status], @cell = "Implemented") + COUNTIFS([CS Status]:[CS Status], @cell = "To Implement")))

Razetto

@Admin When I ran into a formula error I dissect it by adding a helper column for each section. Column 1 for COUNTIFS([CS Status]:[CS Status], @cell = "To Implement"), column 2 for COUNTIFS([CS Status]:[CS Status], @cell = "Implemented")… Or in order to make it work maybe you need these helper columns instead of having too many countifs nested. Hope this helps