Countifs Multiple Criteria

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))

Tags:

Answers

  • Scott Orsey
    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

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!