COUNTIFS multi range multi criteria

Evan M.

Hello all

I'm trying to count how many pending tasks with team 3 for site 1

I'm using this formula but it's not working, please help :)

=COUNTIFS(Site1:Site8, HAS("Site 1"), [Task status]1:[Task status]8, "Pending"), Team1:Team8, "team 3")

Kelly Moore

Hey @Evan M.

Try this

=COUNTIFS(Site:Site, HAS(@cell, "Site 1"), [Task Status]:[Task Status], "Pending", Team:Team, "Team 3")

cheers

Kelly Moore

Hey @Evan M.

Try this

=COUNTIFS(Site:Site, HAS(@cell, "Site 1"), [Task Status]:[Task Status], "Pending", Team:Team, "Team 3")

cheers

Evan M.

@Kelly Moore thank you very much it worked!