#UNPARSEABLE using COUNTIF and cross-sheet Reference

luke_morales

This feels like a dumb question.

I'm trying to get a count of total "To Do" items in the entire Status column from the Team SCRUM: Communications sheet. This function is working fine without the cross-sheet reference, but nothing I've tried is working to correct the issue.

The formula is as follows:

=COUNTIF({Team SCRUM: Communications STATUS Column}Status:Status, "To do")

Any pointers?

Genevieve P.

Hi @luke_morales

It looks like you have the column listed twice... once in the {cross sheet} range, and then again as an in-sheet column reference of Status:Status.

Try just having the {cross sheet} and the "Criteria", like so:

=COUNTIF({Team SCRUM: Communications STATUS Column}, "To do")

Let me know if that worked for you!

Cheers,

Genevieve

Genevieve P.

Hi @luke_morales

It looks like you have the column listed twice... once in the {cross sheet} range, and then again as an in-sheet column reference of Status:Status.

Try just having the {cross sheet} and the "Criteria", like so:

=COUNTIF({Team SCRUM: Communications STATUS Column}, "To do")

Let me know if that worked for you!

Cheers,

Genevieve

luke_morales

@Genevieve P. This is fantastic and simple! Solved completely!

Thank you so much,

Luke

Genevieve P.

I'm so glad to hear it! I hope you have a good weekend. 🙂