UNPARSEABLE error using COUNTIFS

I am using the following formula to count all bids that were won in the month of January by looking for January in the "Awarded CT Reported Date" column and has a "Y" in the "Won Bid?" column. Both statements work independently, but when I combine them I keep getting an unparseable error. What am I doing wrong?

=COUNTIFS([Awarded CT Reported Date]:[Awarded CT Reported Date], IFERROR(MONTH(@cell), 0) = 1), [Won Bid?]:[Won Bid?], "Y"

Find more posts tagged with

Accepted answers

All comments

Leibel S

@David Langley

Looks like you are missing a closing parentheses.

Mike Wilday

@David Langley There is an accidental closing parenthesis after =1

Try this one:

=COUNTIFS([Awarded CT Reported Date]:[Awarded CT Reported Date], IFERROR(MONTH(@cell), 0) = 1, [Won Bid?]:[Won Bid?], "Y"

@Leibel S Smartsheet will auto-close any missing parenthesis (or it used to). So in this case that wasn't the issue. The closing parenthesis ended the Countifs early and there was still extra data that was trying to be factored in to the equation.

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.