COUNTIFS returning #INCORRECT ARGUMENT SET

michelle.lewis-miller

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?

 

IanN

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!