Countifs, Date Functions and Text Criteria

I am putting together two sets of formulas so I can capture the number of tasks within a certain year and month, and another set to see which of those are completed.

My formula that works to capture the number of tasks is (in this example, January 2024:

=COUNTIFS({GA Date}, IFERROR(MONTH(@cell), 0) = 1, {GA Date}, IFERROR(YEAR(@cell), 0) = 2024)

Now, I want to make a new formula to see if the Status is "Completed":

=COUNTIFS({GA Date}, IFERROR(MONTH(@cell), 0) = 1, {GA Date}, IFERROR(YEAR(@cell), 0) = 2024, {Status}, "Completed")

Now I am receiving an INCORRECT ARGUMENT SET error and not sure why. Both column ranges are the same, and I don't see any missing arguments or extra functions (as the documentation says).

Find more posts tagged with

Formulas

Accepted answers

JamesB

@James Tontarski I would move around you criterion, just to keep your nested formulas at the end. Then I would ask does your Status column on your other sheet have a formula that may be returning in error. If you have errored cells in your formula reference data, it will cause issues with your formula unless you have the IFERROR callout.

=COUNTIFS({Status}, "Completed",{GA Date}, IFERROR(MONTH(@cell), 0) = 1, {GA Date}, IFERROR(YEAR(@cell), 0) = 2024)

Edited to fix my formula mistake.

All comments

JamesB

=COUNTIFS({Status}, "Completed",{GA Date}, IFERROR(MONTH(@cell), 0) = 1, {GA Date}, IFERROR(YEAR(@cell), 0) = 2024)

Edited to fix my formula mistake.

James Tontarski

Thanks @JamesB, rearranging the criterion worked. The Status column in the other sheet has no formulas, just text.

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.