Problem with a COUNTIFS formula

Ivan Perez

Hello I am having problems with this formula =COUNTIFS(Date:Date, AND(IFERROR(YEAR(@cell), 0) = 2021, Reviewer:Reviewer, "IP")) I get a #INVALID DATA TYPE Error. Not sure what I am doing wrong.

Thank you for your help.

Genevieve P.

Hi @Ivan Perez

COUNTIFS doesn't need to have an AND statement because of the S at the end makes the function plural. This means you can list each range and criteria after another and the COUNTIFS knows that you mean "and"!

Try:

=COUNTIFS(Date:Date, IFERROR(YEAR(@cell), 0) = 2021, Reviewer:Reviewer, "IP")

Cheers,

Genevieve

BullandKhmer

Check the column format settings, it may just be that the column was set to date format when it should be text.

Hope that helps, if it doesn't let us know.

AJ.

Ivan Perez

The Reviewer column is set up as a Dropdown (Single Selection) can that be causing the error.

Genevieve P.

Hi @Ivan Perez

COUNTIFS doesn't need to have an AND statement because of the S at the end makes the function plural. This means you can list each range and criteria after another and the COUNTIFS knows that you mean "and"!

Try:

=COUNTIFS(Date:Date, IFERROR(YEAR(@cell), 0) = 2021, Reviewer:Reviewer, "IP")

Cheers,

Genevieve

Ivan Perez

Thank you that work.