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
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks everyone!! It's working now. Really appreciate the help!
-
Happy to help!
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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:
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!