COUNTIFS Formula

Good morning,

I am trying to do a COUNTIFS formula and getting a #Unparseable error here is the formula I am trying to set up.

=COUNTIFS([Date]:[Date],(IFERROR(YEAR(@cell), 0) = 2022, IFERROR(MONTH(@cell), 0) = 12),([Exception Category]:[Exception Category], "TILA/RESPA"))

Thanks for your help.

Find more posts tagged with

Accepted answers

Samuel Mueller

@Ivan Perez You need the conditional equation in your iferror statement. It also always follows criteria range, then criteria for each set.

=COUNTIFS([Date]:[Date], IFERROR(YEAR(@cell) = 2022, 0), [Date]:[Date], IFERROR(MONTH(@cell) = 12, 0), [Exception Category]:[Exception Category], "TILA/RESPA")

if you wanted year and month combined, you could do that with the and function.

=COUNTIFS([Date]:[Date], and(IFERROR(YEAR(@cell) = 2022, 0), IFERROR(MONTH(@cell) = 12, 0)), [Exception Category]:[Exception Category], "TILA/RESPA")

Let me know if that works.

All comments

Samuel Mueller

@Ivan Perez You need the conditional equation in your iferror statement. It also always follows criteria range, then criteria for each set.

=COUNTIFS([Date]:[Date], IFERROR(YEAR(@cell) = 2022, 0), [Date]:[Date], IFERROR(MONTH(@cell) = 12, 0), [Exception Category]:[Exception Category], "TILA/RESPA")

if you wanted year and month combined, you could do that with the and function.

=COUNTIFS([Date]:[Date], and(IFERROR(YEAR(@cell) = 2022, 0), IFERROR(MONTH(@cell) = 12, 0)), [Exception Category]:[Exception Category], "TILA/RESPA")

Let me know if that works.

Ivan Perez

Hello Samuel,

Thank you for taking the time to respond to my post. Your solution worked perfectly.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.