Countifs Multiple Criteria

ginamt3

I'm trying to count all the "Reserve" jobs for the year 2023. it's reporting 0. What am I doing wrong.

=COUNTIFS({NEW SALES - DATABASE Range 2}, "Reserve", {NEW SALES - DATABASE Range 1}, (IFERROR(YEAR(@cell), 0) = 2023))

Scott Orsey

Hi, It's hard to know. I would consider making a helper column in your NEW SALES - DATABASE sheet that contains the YEAR() for each row and use that helper column in the COUNTIFS instead of the actual date. You wouldn't need the IFERROR(YEAR()) in that case and it would simplify things. If that doesn't help, then try evaluating the two halves of the COUNTIFS individually. That might help you know which condition is causing 0 matches.

Be well