COUNTIFS returning 0

I am having an issue with the formula below. I am attempting to get the count where the year of {Conv Rec 020} equals the cell "2020" and the month of {Conv Rec 020} equals 1 (aka: January). I have quoted the 1 and get the same results.

The formula is returning "0"... any thoughts to return the correct values? It should be 57.

=COUNTIFS(IFERROR(YEAR({Conv Rec 020}), 0), =Year1, IFERROR(MONTH({Conv Rec 020}), 0), 1)

{Conv Rec 020} is a DATE column from the referenced sheet

Year1 = 2020

Find more posts tagged with

Formulas

Cell linking

Accepted answers

Kelly Moore

Two curly brackets are out of place. Add a curly bracket immediately after the Countif parenthesis. Remove curly bracket ahead of @cell. I had caught these errors last night and corrected but somehow the editing didn't 'stick' when I posted.

All comments

Kelly Moore

Hey

try this

=COUNTIFS({Conv Rec 020},IFERROR(YEAR(@cell), 0) =Year1, {Conv Rec 020},IFERROR(MONTH(@cell), 0)=1)

Rebekah Valdez-Pound

@KDM I am getting the infamous #UNPARSEABLE error with that formula

Kelly Moore

Rebekah Valdez-Pound

@KDM

Eureka- It worked!! Thank you so much for your help!

=COUNTIFS({Conv Rec 020}, IFERROR(YEAR(@cell), 0) = Year1, {Conv Rec 020}, IFERROR(MONTH(@cell), 0) = 1)

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.