Countifs / Contains

reece.buckner

Hello all,

I had this formula working, I'm not sure what I changed to make it stop working. I've looked at it and played with it to get it working again and it won't. Please someone show me what I'm doing wrong.

=COUNTIFS([Due this Week]:[Due this Week], 1, Status:Status, CONTAINS("In Progress", @cell))

I just want to count how many tasks are In Progress This Week.

L_123

Look down the columns that you are referencing. I bet you will find a formula error inside of one of them that you will have to fix

L_123

error in one of your ranges most likely

Sameer Karkhanis

You can keep it simple instead,

=COUNTIFS[Due this Week]:[Due this Week], 1, Status:Status, "In Progress") 

reece.buckner

I tried that, it tells me INVALID DATA TYPE. I have tried several versions of this formula in different ways and it always tells me invalid data type.

reece.buckner

@L_123 can you please elaborate on this? I am not sure what that error may be. It is referencing two existing columns, it isn't a problem with the column name within the formula. I changed the column type for Due this Week from text which read "This Week" to the checkbox, which did not make a difference.

L_123

Look down the columns that you are referencing. I bet you will find a formula error inside of one of them that you will have to fix

reece.buckner

@L_123 That was it, thank you!