COUNTIFS Statement Help

edited 12/09/19 in Formulas and Functions
03/27/18 Edited 12/09/19

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")


Popular Tags:


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

  • Glen Walter TelesGlen Walter Teles ✭✭✭✭✭

    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.