COUNTIFS Current Year

Jill Markham

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

Amber Eakin

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!

Mike TV

@Jill Markham

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

Amber Eakin

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!

Jill Markham

@Amber Eakin THANK YOU. That did it.

Mike TV

@Jill Markham

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