COUNTIFS Statement Help

Emily Swartz

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.

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

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