COUNTIFS Statement Help

Emily Swartz
Emily Swartz ✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to COUNTIFS but have been unsuccessful so far. I need to count the status of a project if it is a certain product. I keep getting #INCORRECT

=COUNTIFS(Status3:Status51, "Green", Product:Product, "Rapid Test")

Thanks.

Tags:

Comments

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Hi eswartz,

    You're seeing the error because your 2 ranges are different sizes. The first range is dealing with 49 rows, while the second is looking at the whole column.

    If you change the formula to the following, you'll be good:

    =COUNTIFS(Status:Status, "Green", Product:Product, "Rapid Test")

  • To add to the above

    Or you can keep the same column ranges for both the columns

    =COUNTIFS(Status3:Status51, "Green", Product3:Product51, "Rapid Test")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!