# Cross Reference Countif Formula is giving Unparsable Error.

Options
✭✭✭

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))

Tags:

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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))

bassam.khalil2009@gmail.com

• ✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
Options

You got it Heather, thank you!

• ✭✭✭✭✭✭
Options

Happy to help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!