COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here.
I'm trying to count rows in another sheet ("Sheet A") where both the following are true:
- Done = 0
- IsChild = 0
My formula is:
- =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0)
Now this works perfectly!
So in a cell right below that one, I then try to count rows in Sheet A where both of these criteria are true:
- Done = 0
- Sub-Category = "Key Initiative"
My formula is:
- =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 5}, "Key Initiative")
And this doesn't work! It's basically the formula as the above so I'm baffled as to why this one returns an #INCORRECT ARGUMENT SET result while the first one works perfectly? Any ideas?
Comments
-
Hi Michelle,
I looked at our Help Center article for Formula error messages: https://help.smartsheet.com/articles/2476176-formula-error-messages.
From your description, it's hard to see what the ranges actually are, but it's possible that the ranges sizes don't match, and they would need to.Try editing your ranges to be the same size.
If that doesn't resolve the issue, I'd recommend reaching out to our Support Team and we can assist further: https://help.smartsheet.com/contact
Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!