UNPARSEABLE error using COUNTIFS
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"
Help Article Resources
Check out the Formula Handbook template!