COUNTIFS Statement Help

COUNTIFS Statement Help

eswartzeswartz
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.

Tagged:

Comments

  • Chris McKayChris 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")

Sign In or Register to comment.