IFERROR MONTH

Owen Smith · 05/14/21

#UNPARSEABLE error when adding the MONTH function.

=COUNTIFS({Incoming Quality 1}, Quality@row, {Intake Sheet Range 1}, IFERROR(MONTH(@cell),0) = 4))

Kimberly Loveless · 05/14/21

I think you just have an extra parenthesis at the end, so I think it should be

=COUNTIFS({Incoming Quality 1}, Quality@row, {Intake Sheet Range 1}, IFERROR(MONTH(@cell),0) = 4)

This help article is great for figuring these out, I use it regularly

Owen Smith · 05/14/21

Yes, Thank you.

Paul Newcome · 05/14/21

Are you able to provide a screenshot of the formula in the sheet similar to the below?

Kimberly Loveless · 05/14/21

I think you just have an extra parenthesis at the end, so I think it should be

=COUNTIFS({Incoming Quality 1}, Quality@row, {Intake Sheet Range 1}, IFERROR(MONTH(@cell),0) = 4)

This help article is great for figuring these out, I use it regularly

Owen Smith · 05/14/21

Yes, Thank you.

Paul Newcome · 05/14/21

@Kimberly Loveless Good catch. That's usually one of the first things I look at. I'm not sure why I didn't this time. Thanks!!

Best Answers