COUNTIFS Current Year

Looking to count those with a Project Status of closed for those with an End Date in the current year. My formula results in a #INVALID OPERATION. Can someone assist me with what I'm overlooking?

=COUNTIFS([Project Status]:[Project Status] = "Closed", [End Date]:[End Date], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Regards,

Jill


Best Answers

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    edited 01/31/23 Answer ✓

    Hello, @Jill Markham . There's a slight error in your formula. Rather than a = after the project status, you need a comma.

    =COUNTIFS([Project Status]:[Project Status], "Closed", [End Date]:[End Date], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

    I hope that helps!

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @Jill Markham

    =COUNTIFS([Project Status]:[Project Status], "Closed", [End Date]:[End Date], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!