Problem with a COUNTIFS formula

Options

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.

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!