I am trying to count how many items fit 2 criteria, one is the year, the other is the state. The issue is coming in with the state, as I just changed it to a VLOOKUP and my formulas were all working before I did that. The VLOOKUP is working, but there are a few values which return a #NO MATCH and I can't change that due to the nature of those particular rows.
I am now getting a #NO MATCH error for all of my COUNTIFS formulas.
I saw this post <https://community.smartsheet.com/discussion/errors> and it seems like a similar problem, but the solution didn't work for me. I'm not sure if I'm implementing it wrong?
Here is my formula:
=COUNTIFS([Project Year]:[Project Year], "2019", State:State, IFERROR(@cell, 0) = "AL")
Any help is appreciated! I've been staring at this all day!