Cross Reference Countif Formula is giving Unparsable Error.

I am hoping someone can help with Countifs formula referencing another sheet.

The current formula that I have works great on the master sheet. =COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31))

However, when I modify on another sheet to read as what is listed below I am getting an Unparsable error. Can anyone see any issues?

=COUNTIFS({2021 Resolved Dates},[Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1),{2021 Resolved Dates},[Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31))

Find more posts tagged with

Formulas

Cell linking

Accepted answers

Heather Duff

Hi @JP Pedicino

Try this:

=COUNTIFS({2021 Resolved Dates}, @cell >=DATE(2021, 3, 1), {2021 Resolved Dates}, @cell <=DATE(2021, 3, 31))

Hopefully that will fix your problem.

Best,

Heather

All comments

Bassam Khalil

Hi @JP Pedicino

Hope you are fine, please try the following formula:

=COUNTIFS({2021 Resolved Dates}, >=DATE(2021, 3, 1), {2021 Resolved Dates}, <=DATE(2021, 3, 31))

JP Pedicino

Bassman,

Unfortunately, that was not the solution. To further clarify I created my formula on a sheet called "Tickets Resolved Month Over Month. I need the formula below to reference another sheet named "2021 Resolved Dates". The formula should count the number of times the "Resolved Date" is within March of 2021.

=COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31))

Something appears to be wrong with my syntax referencing the other sheet because the formula works perfect on the the original sheet "2021 Resolved Dates" where I created it.

Heather Duff

Hi @JP Pedicino

Try this:

=COUNTIFS({2021 Resolved Dates}, @cell >=DATE(2021, 3, 1), {2021 Resolved Dates}, @cell <=DATE(2021, 3, 31))

Hopefully that will fix your problem.

Best,

Heather

JP Pedicino

You got it Heather, thank you!

Heather Duff

Happy to help!

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.