COUNTIFS multi range multi criteria


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!