UNPARSEABLE error using COUNTIFS

Options

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"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!