Trying to use COUNTIFS and keep getting UNPARSEABLE error

marybeth.grant96761

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!

 

L_123

youare missing your curly brackets on your other sheet references.

Nasir@EBC

Hi 

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