Trying to use COUNTIFS and keep getting UNPARSEABLE error

Hi,

I've entered this statement:

=COUNTIFS(PMO Project RAG Status Range 5, <DATE(2019, 12, 31), (PMO Project RAG Status Range, "Corporate Support - Corporate Finance")

What I'm trying to do is count the number of projects with the designation of Corporate Support - Corporate Finance that will be delivered in 2019.

The Range 5 sheet reference is for the list of dates. I've successfully used the following statements correctly individually. Can anyone see any obvious errors?

=COUNTIF({PMO Project RAG Status Range}, "Corporate Support - Corporate Finance")

=COUNTIF({PMO Project RAG Status Range 5}, <DATE(2019, 12, 31))

Thanks for your help!

Find more posts tagged with

Formulas

Accepted answers

All comments

L_123

youare missing your curly brackets on your other sheet references.

Nasir@EBC

The problem lies in selecting the range from the external sheet.

If the external sheet-range contains any blank cells then it will generate the "#INCORRECT ARGUMENT SET" error.

Please try selecting only the populated / data-filled cells from in the external-sheet range reference. At present I can say this is the only way out!

Best

Nasir

Paul Newcome

Since your two formulas work individually, your first formula should work with 2 corrections...

1. L@123's point of the curly brackets around your cross-sheet references { }.

2. Remove the opening parenthesis before the PMO Project RAG Status Range

marybeth.grant96761

Thanks everyone!! It's working now. Really appreciate the help!

Paul Newcome

Happy to help!

DVS_Helen

Having same problem with Unparseable:

=COUNTIF({DVS Vacancy Tracker}[Status]152:[Status]162,="Filled")

I'm trying to count the number of cells in a Status column that have the word "Filled in the cells. Thanks.

Paul Newcome

@DVS_Helen Your range is incorrect. How exactly are you creating your cross sheet reference?

Take a look at this to help you get started:

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

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.