UNPARSEABLE error using COUNTIFS

David Langley

I am using the following formula to count all bids that were won in the month of January by looking for January in the "Awarded CT Reported Date" column and has a "Y" in the "Won Bid?" column. Both statements work independently, but when I combine them I keep getting an unparseable error. What am I doing wrong?

=COUNTIFS([Awarded CT Reported Date]:[Awarded CT Reported Date], IFERROR(MONTH(@cell), 0) = 1), [Won Bid?]:[Won Bid?], "Y"

Leibel S

@David Langley

Looks like you are missing a closing parentheses.

Mike Wilday

@David Langley There is an accidental closing parenthesis after =1

Try this one:

=COUNTIFS([Awarded CT Reported Date]:[Awarded CT Reported Date], IFERROR(MONTH(@cell), 0) = 1, [Won Bid?]:[Won Bid?], "Y"

@Leibel S Smartsheet will auto-close any missing parenthesis (or it used to). So in this case that wasn't the issue. The closing parenthesis ended the Countifs early and there was still extra data that was trying to be factored in to the equation.