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!
Answers
-
youare missing your curly brackets on your other sheet references.
-
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
-
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
-
Thanks everyone!! It's working now. Really appreciate the help!
-
-
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.
-
@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:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!