Countif function with multiple conditions

Joechaptaylor

Hi,

I am attempting to set a counter wherby i reffernce my main sheet, checking if the department is Fleet, If the Urgency is High, and to only count if the status is EITHER In Progress, or Not Started, this gets rid of the completed tasks for my counter.

Im using the below, refferencing a sheet "Front Door Requests", the range 1 and range 2 is auto populated when i reference the sheet using the smartsheet link tool.

Any ideas why this doesnt work?

=COUNTIFS({Front Door Requests Range 1}, "Fleet", {Front Door Requests Range 2}, "High", {Front Door Requests Range 3}, "In Progress", OR({Front Door Requests Range 3}, "Not Started")))

Nick Korna

Hi @Joechaptaylor,

The OR portion of your formula is not quite right here. Try amending to:

=COUNTIFS({Front Door Requests Range 1}, "Fleet", {Front Door Requests Range 2}, "High", {Front Door Requests Range 3}, OR(@cell="In Progress",@cell="Not Started"))

Hope this helps, but let us know if you still have any problems/questions!